SendObject multiple reports

[Carol]

I have been successful in sending 1 report via email using
send object. I would like to send 3 different reports
(same database) in the same email. Please let me know how
to add two more reports.
Thanks
c

 

[Cheryl Fischer]

Carol,

Unfortunately, as far as I know, the SendObject method can send only a
single attachment automatically. You might want to investigate using
Automation with Outlook, which will allow you to add multiple attachments.
Note that SendObject performs the conversion of your report to the format
you select, so you will have to handle that yourself before running your
Automation code. There is sample code at the following links that can get
you started:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Also, have a look at Tony Toews' email page:

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