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

How to attach 2 reports to e-mail

P: 8
Hi.

Can anybody help with this small problem.

I'm currently using Access 2003 and from within the database i need to e-mail 2 x different reports on the same e-mail.

I've managed to do this by running a macro with the "sendobject" function but this only allows me to attach 1 report.

Any advice on this would be greatly appreciated.

Thanks
Oct 5 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
The macro solution will only support one attachment. To have multiple reports emailed you can issue the same command per report and thus create two emails or try to create a new report with two subreports to combine them before mailing.

When you need two attachments, the only option will be to use VBA code to attach both reports. This article shows how:
http://support.microsoft.com/kb/209948/en-us

Nic;o)
Oct 5 '07 #2

Post your reply

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