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

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

http://www.rondebruin.nl/sendmail.htm
--
If this post helps click Yes
---------------
Jacob Skaria


"Peter" wrote:

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

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

"Jacob Skaria" wrote:

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

http://www.rondebruin.nl/sendmail.htm
--
If this post helps click Yes
---------------
Jacob Skaria


"Peter" wrote:

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