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

[RobH]

i currently send a report to a reciepient using the Docmd.Sendobjec t acSendReport which works really well - now my customer wants two reports sent in the same email..

Any thoughts???

[ollyb303]

i currently send a report to a reciepient using the Docmd.Sendobjec t acSendReport which works really well - now my customer wants two reports sent in the same email..

Any thoughts???

You could use:

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.