Sendobject with multiple reports

[Susan W]

I need to give the user to send multiple reports in one
email. I cannot find anything that allows me to do that
with SendObject. Does anyone know how to do this?

Please help!
Sue

 

[Cheryl Fischer]

Susan,

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.
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


hth,

 

[Susan W]

Thanks! this will help. You would think that SendObject
would allow it since it allows multiple recipients.
Sue