email multiple attachments

[Guest]

I'm trying to set up a way to email multiple reports in snapshot format in a
single email. Is there a way to do it? Right now, the max number of reports
I would need in one email is five.
Chuck

 

[Scott McDaniel]

I'm trying to set up a way to email multiple reports in snapshot format in a
single email. Is there a way to do it? Right now, the max number of reports
I would need in one email is five.

AFAIK, you cannot combine multiple snapshot reports into one single report. You could, perhaps, build a report which
includes those reports, but I doubt that would work for you.

You could output your reports, then attach them to an Outlook email. You may even be able to automate a zip program
(like Winzip) to combine them into a single file.

I've got a sample db on my site that shows how to automate Outlook and handle attachments:

www.infotrakker.com\progsamples\OutlookEmail.zip


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Tony Toews]

I'm trying to set up a way to email multiple reports in snapshot format in a
single email. Is there a way to do it? Right now, the max number of reports
I would need in one email is five.

You can have multiple attachments in an email but not using
SendObject. You'll have to use other methods.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

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