Email several objects in one message

[Mike]

I would like to create a button on my form which should
email two reports in snp-format in one message.
Is it possible with SendObject method or I can send them
only separately?

 

[Cheryl Fischer]

Unfortunately, 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