Attaching Reports to Email

[Hasan]

Is it possible to attach 2 MS Access (97) reports to 1
email with the DoCmd SendObject. I am able to use attach
under a command button to 2 seperate emails but require
it for 1.

Please include syntax if possible.
Thanks
Hasan

 

[keith]

you can do it by using automation. SendObject is
probably not going to allow you to do it.

To do it with automation, check this out:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;161088&Product=acc

That should be exactly what you need.

Good luck!

 

[Cheryl Fischer]

Here is a link with code to create emails (with attachments), appointments,
etc., using Outlook automation

http://tinyurl.com/2knwj

hth,