By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,575 Members | 1,395 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,575 IT Pros & Developers. It's quick & easy.

how to send two reports in one email via DoCmd.SendObject acSendReport,

RobH
P: 56
i currently send a report to a reciepient using the Docmd.Sendobject acSendReport which works really well - now my customer wants two reports sent in the same email..

Any thoughts???
Feb 14 '08 #1
Share this Question
Share on Google+
1 Reply


ollyb303
P: 74
i currently send a report to a reciepient using the Docmd.Sendobject acSendReport which works really well - now my customer wants two reports sent in the same email..

Any thoughts???
You could use:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF, "C:\ReportName.rtf"
twice to output your two reports and then use a function to access your email client, attach the two files and send.

I use this very successfully at the moment to send multiple reports via Lotus Notes and can give you the function I use to do this. I'm afraid if it's not Notes I can't really help with this bit, but the theory's the same!

Just a thought.
Feb 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.