Multi attachments in an email

[Dan]

hi,

is there a way to send more than 1 attachment in an email
via a macro?

i'm using the sendobject action and sending a report in
rich text format to an email address... there doesn't
seem to be an area for more than 1 object to send...

thanks,
dan

 

[Van T. Dinh]

Correct. SendObject can only handle 1 object.

If you want to have more attachments, you need to use Outlook Automation or
CDO. Tony Toews has a comprehensive article on e-mail from Access at:

http://www.granite.ab.ca/access/email.htm

 

[Dan]

Thanks so much Jim... I made a couple of minor adjustments and that worked great...