ACCESS Reports

I have an Access application that has multiple reports. I
have created a macro to create all the reports in preview.
The problem that I have is that I need a method to attach
all the reports to a single Email. I have created a macro
to create the reports, but it will only attach one report
to the email. Any ideas how to send all the reports in a
single email? The users want to click on a single button
to send all the reports.

"Steve" wrote in message
...
I have an Access application that has multiple reports. I
have created a macro to create all the reports in preview.
The problem that I have is that I need a method to attach
all the reports to a single Email. I have created a macro
to create the reports, but it will only attach one report
to the email. Any ideas how to send all the reports in a
single email? The users want to click on a single button
to send all the reports.

There is nothing built in to Access that will do this. You would have to
use OutputTo to create external files for each report and then automate an
Email program/library to create an Email message and attach the files.

The only other alternative would be to embed all of the reports as
subreports in a single unbound "container" report and then use SendObject
on that.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

We have some example code on how to use our product to:
- create pdf files
- build emails and attach the pdf files (can be multiple per email)
- send the emails.

HTH,
Mark
RPT Software
http://www.rptsoftware.com

PS: Sample is in the eval for the batch reporting module.

"Steve" wrote in message
...
I have an Access application that has multiple reports. I
have created a macro to create all the reports in preview.
The problem that I have is that I need a method to attach
all the reports to a single Email. I have created a macro
to create the reports, but it will only attach one report
to the email. Any ideas how to send all the reports in a
single email? The users want to click on a single button
to send all the reports.