Sending multiple reports from Access using Outlook.

S

StephWhitley

I have about 160 reports and I need to send several of them at a time using a
command button instead of one at a time to the same person. I've tried
several things, none of which work. Please help.
--
Steph

P.S. By the way I've found several solutions to problems from this forum
but couldn't get the feedback thing to work. So thanks to all who have
helped me in the past and hopefully to those who help me with this.
 
T

Tony Toews

StephWhitley said:
I have about 160 reports and I need to send several of them at a time using a
command button instead of one at a time to the same person. I've tried
several things, none of which work. Please help.
Click to expand...

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

However you won't be able to use SendObject to send the emails as it
only supports one attachment. Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm for alternatives.

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
 
Top