If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combine Multiple Reports to send in Email Attachment
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. |
#2
|
|||
|
|||
Combine Multiple Reports to send in Email Attachment
"Steve" wrote:
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. 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 |
Thread Tools | |
Display Modes | |
|
|