Open an email and attach my excel file
 

I am comfortable with VBA for Excel. Now I want to move beyond Excel. I
would like to add something to my code that, after saving the file, will open
an Outlook email, enter a specific distribution list from my contacts and
attach the excel file. I know that's a lot to ask for, but just a starting
point (e.g. the VBA script to open a new email) would be helpful.

Anyone? Thanks.

Open an email and attach my excel file
 

Hi
have a look at:
http://www.rondebruin.nl/sendmail.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"benb" schrieb im Newsbeitrag
...
I am comfortable with VBA for Excel. Now I want to move beyond Excel. I
would like to add something to my code that, after saving the file, will
open
an Outlook email, enter a specific distribution list from my contacts and
attach the excel file. I know that's a lot to ask for, but just a
starting
point (e.g. the VBA script to open a new email) would be helpful.

Anyone? Thanks.