Sending multiple reports

  • Thread starter Thread starter Dennis
  • Start date Start date
D

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?
 
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.
 
thank you for the information.
since i do not have any other program that you had said.
and i am not able to get them on this PC. would you have
any idea on how i could save snapshots of these reports to
a seperated folder with a click of a command button
without have to set up 10 buttons for each report?.
thanks
 
Dennis:

Look in the help file for the OutputTo method. Specify a "Snapshot Format"
in the format parameter.
 
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.
 
Back
Top