Sending multiple reports

[Dennis]

I am trying to set up a command button to E-Mail some
reports (10). How can i attach all of them to the same
button to be sent as one E-Mail message?

 

[SA]

Dennis:

Access' built in Send Object Method, as you've found, doesn't support
multiple attachments. To support that type of functionality you need a
third party tool. There are numerous Active X mail controls out there (e.g
mabry.com). You can of course automate Outlook (using code that can be
found in the MS Knowledgebase or in the MSDN Library). Our PDF and Mail
Library for Access will also allow you to attach mutiple files to a mail
item, either Snapshot reports generated natively by Access or Adobe PDF
files of those reports.

 

[SA]

Dennis:

Look in the help file for the OutputTo method. Specify a "Snapshot Format"
in the format parameter.

 

[Dennis]

I figured it out to the easiest way i could. i made a
report with all subreports. there for now i have one
report that is about 13 pages.
thanks for your input though.