MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SendMail Command

Posted by Douglas on November 15, 2001 9:18 AM


I've written a macro which splits up a sales report into 15 regions (separate files, eg Sales Report Region 1 - Week 1.xls) and then, in turn e-mails each report to the respective region.

The e-mail part of my macro uses SendMail, with arg1 as the e-mail address and arg2 as the subject.

Ideally I'd like to add a message in the main body of the mail - is this possible using VBA??

Thanks in advance,

Posted by Jack on November 15, 2001 3:56 PM

Please post your VB Code to look at for amending