multiple attachments

[Jon M.]

Greetings friends,
I have three reports that I need to email. I can email them individually
without a problem using a send object command, but is there a way to
consolidate them all into one email? Basically one email with 3 attachments?
Or something along those lines? As always I appreicate any help I can get.

The code I'm using is:

DoCmd.SendObject acSendReport, "MenuReport", acFormatRTF, "(e-mail address removed)",
, , "Cafeteria Menus"

 

[Jon M.]

This helps a great deal. My reports aren't generally being saved ahead of
time but they could. Is there something I could that would run the report
and automatically save it in word or as a snapshot?

 

[Bob Quintal]

This helps a great deal. My reports aren't generally being saved
ahead of time but they could. Is there something I could that
would run the report and automatically save it in word or as a
snapshot?

Stephen Lebans has a wonderful tool that allows to save as .pdf (or as
a .snp).

http://www.lebans.com/reporttopdf.htm

 

[Arvin Meyer MVP]

Sure, save as a snapshot or PDF. I sometime use Stephen Lebans free PDF
creator which works within Access:

http://www.lebans.com/reporttopdf.htm