Macro for e-mail

[xapoodax]

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.

 

[Alan]

Have a look here,
http://www.rondebruin.nl/sendmail.htm

 

[Mike Fogleman]

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

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

Mike F

 

[xapoodax]

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.

 

[Alan]

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.

 

[Ron de Bruin]

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

 

[xapoodax]

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

 

[xapoodax]

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]

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"" <[email protected]>"

 

[xapoodax]

Thank you!!!

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"" <[email protected]>"