Sending more then 1 Access Report to Outlook

15 pts.
Tags:
Microsoft Access
Microsoft Access 2007
Microsoft Access reports
Microsoft Outlook
Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes, I have also noticed that Access 2007 mails only one report at a time.
I generally export the reports to .pdf files & then send the reports via Outlook mail, as attachments. Just right click on the report & then select Export as .pdf.

Note: It does require proper .pdf executables to be installed. If not, the system will guide on installing pdf. I realize this is not best solution but this is the way I am circumventing Access 2007 shortcomings.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JulieSandra
    Thanks for replying. I am exporting the Reports as .pdf files in two emails. I just thought it would be better to have one email with 2 attachments. It dosnt look like I am going to be able to do this without some major coding. Thanks again
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following