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,