Automated sheet email

[Adam Gibbins]

Hi,
I'm looking for a way to automate the emailing of a single sheet from
a workbook.
The catch is, that the sheet contents must be within the email's body,
not as an attachment.

Any ideas would be much appreciated.

Many thanks.

 

[Ron de Bruin]

Hi Adam

If you use Outlook

See
http://www.rondebruin.nl/mail/folder3/mail2.htm

Or
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm

You can find a example workbook to test the code on the index page (See body section)
http://www.rondebruin.nl/sendmail.htm


If you not use Outlook post back