Email worksheet using VBA Code

[E-News]

Hi, I see there are other posts about emailing, so I'll ask my question as
well.

I have a list of workbooks and the emails to which I want to send the
workbooks, one workbook per email.

I have working code that opens the workbooks and creates an email in Outlook
that has the workbook as an attachment, but the email address is no longer
in the workbook when it arrives in Outlook except for the workbooks in which
I listed my own email. Any thoughts on that?

Also I would like to put a message in the email, along with the attachment
and can't find an argument for that except in the routing code, and this is
not a routing situation. Anyone know of code that does what I need?

Thanks in advance.

Mardee

 

[Ron de Bruin]

Try this example

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

See the example to send a range to each person for
a example to change the Body line