Jim
You may want to take a look at Ron de Bruin's site for tips on sending mail.
Lotsa code and routines and a SendMail add-in which will do what you want.
http://www.rondebruin.nl/sendmail.htm
Gord Dibben MS Excel MVP
>Is it possible to make a template for the Send To Mail Receipant as
>Attachment in Excel 2003 so that the e-mail addresses, subject and body will
>already be filled out and then just have Excel attach the spreadsheet?
>Thanks
>
>Jim
Jim - 26 Jan 2007 17:17 GMT
Thanks, we were able to do what we needed with a distribution list.
> Jim
>
[quoted text clipped - 14 lines]
>>
>>Jim