Macro for e-mail
 

Is there a way to code for sending a selection of cells as a body of an
e-mail and then attach a file to said e-mail? Also I'm looking for help on
being able to automate changing of the "From" field in this e-mail to reflect
an alias. Thanks in advance.

Macro for e-mail
 

Have a look here,
http://www.rondebruin.nl/sendmail.htm
"xapoodax" wrote in message
...
Is there a way to code for sending a selection of cells as a body of an
e-mail and then attach a file to said e-mail? Also I'm looking for help on
being able to automate changing of the "From" field in this e-mail to
reflect
an alias. Thanks in advance.

Macro for e-mail
 

Check out Ron de Bruins excellent site on emailing from Excel...

http://www.rondebruin.nl/sendmail.htm

Mike F
"xapoodax" wrote in message
...
Is there a way to code for sending a selection of cells as a body of an
e-mail and then attach a file to said e-mail? Also I'm looking for help on
being able to automate changing of the "From" field in this e-mail to
reflect
an alias. Thanks in advance.

Macro for e-mail
 

awesome, I was able to extrapolate the info from the site and create a macro
that does both e-mail as body and attach it as a file. thank you very much
for the link.

On a side note, does anyone know how to change the "From" field in the
e-mail using code? I would have thought it was

With OutMail
.From = ""

but this did not work.

Macro for e-mail
 

I hope the purpose of this isn't for spamming!! I'm sure it's not, but,

'Also I'm looking for help on being able to automate changing of the "From"
field in this e-mail to reflect an alias'

sounds suspicious!

Alan.


"xapoodax" wrote in message
...
awesome, I was able to extrapolate the info from the site and create a
macro
that does both e-mail as body and attach it as a file. thank you very much
for the link.

On a side note, does anyone know how to change the "From" field in the
e-mail using code? I would have thought it was

With OutMail
.From = ""

but this did not work.

Macro for e-mail
 

Read the info on the Tips page (links is on each example page)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xapoodax" wrote in message ...
awesome, I was able to extrapolate the info from the site and create a macro
that does both e-mail as body and attach it as a file. thank you very much
for the link.

On a side note, does anyone know how to change the "From" field in the
e-mail using code? I would have thought it was

With OutMail
.From = ""

but this did not work.

Macro for e-mail
 

Haha no definitely not. Some e-mails I have to send out using my department's
alias.

"Alan" wrote:

I hope the purpose of this isn't for spamming!! I'm sure it's not, but,

'Also I'm looking for help on being able to automate changing of the "From"
field in this e-mail to reflect an alias'

sounds suspicious!

Alan.


"xapoodax" wrote in message
...
awesome, I was able to extrapolate the info from the site and create a
macro
that does both e-mail as body and attach it as a file. thank you very much
for the link.

On a side note, does anyone know how to change the "From" field in the
e-mail using code? I would have thought it was

With OutMail
.From = ""

but this did not work.

Macro for e-mail
 

I took at glance at the Tips page, and there's a good chance I might have
missed something obvious, but I was not able to find anything that touched on
changing the "From" field using outlook as an object.

"Ron de Bruin" wrote:

Read the info on the Tips page (links is on each example page)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xapoodax" wrote in message ...
awesome, I was able to extrapolate the info from the site and create a macro
that does both e-mail as body and attach it as a file. thank you very much
for the link.

On a side note, does anyone know how to change the "From" field in the
e-mail using code? I would have thought it was

With OutMail
.From = ""

but this did not work.

Macro for e-mail
 

Read good

http://www.rondebruin.nl/mail/tips2.htm

Change sender name and reply address

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
..SentOnBehalfOfName = """SenderName"" "






--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xapoodax" wrote in message ...
I took at glance at the Tips page, and there's a good chance I might have
missed something obvious, but I was not able to find anything that touched on
changing the "From" field using outlook as an object.

"Ron de Bruin" wrote:

Read the info on the Tips page (links is on each example page)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xapoodax" wrote in message ...
awesome, I was able to extrapolate the info from the site and create a macro
that does both e-mail as body and attach it as a file. thank you very much
for the link.

On a side note, does anyone know how to change the "From" field in the
e-mail using code? I would have thought it was

With OutMail
.From = ""

but this did not work.

Macro for e-mail
 

Thank you!!!

"Ron de Bruin" wrote:

Read good

http://www.rondebruin.nl/mail/tips2.htm

Change sender name and reply address

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
..SentOnBehalfOfName = """SenderName"" "






--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xapoodax" wrote in message ...
I took at glance at the Tips page, and there's a good chance I might have
missed something obvious, but I was not able to find anything that touched on
changing the "From" field using outlook as an object.

"Ron de Bruin" wrote:

Read the info on the Tips page (links is on each example page)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xapoodax" wrote in message ...
awesome, I was able to extrapolate the info from the site and create a macro
that does both e-mail as body and attach it as a file. thank you very much
for the link.

On a side note, does anyone know how to change the "From" field in the
e-mail using code? I would have thought it was

With OutMail
.From = ""

but this did not work.