Combine Multiple Reports to send in Email Attachment

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have multiple reports in my Access application. I have
created a macro that will produce all the reports in
preview or print mode. I need a way to attach all the
reports to an email. I created a macro to format the
email msg but it will only attach one report to a email.
is there a way to attach all the reports? The users want
to click on a single button to send all the reports.
 
Steve said:
I have multiple reports in my Access application. I have
created a macro that will produce all the reports in
preview or print mode. I need a way to attach all the
reports to an email. I created a macro to format the
email msg but it will only attach one report to a email.
is there a way to attach all the reports? The users want
to click on a single button to send all the reports.
Click to expand...

Yes, but you can't use SendObject. And for that matter you won't be
able to use macro's either. You need to use VBA.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top