Emailing out of Excel

[Peter]

Hi,

Can anyone please help me with some coding to enable me to do the following:

* Email the opened file as attachment to a specific email address. (this
info is within a cell in the spreadsheet.
* Copy some text from the spreadsheet into the body of the email
* Email the file in background without making the user press send

Basically I've extracted some data from an ERP system and then I use Excel
to extract the data each sales guy needs to see then email it to them.

Thanks in advance for your help.
P

 

[Jacob Skaria]

Check out the below link by Ron for different options around emailing

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

 

[Peter]

Many thanks, very good document. It took some time to read and test the
coding but it worked.
Best regards

 

[Jacob Skaria]

Thanks to Ron.

If this post helps click Yes