send multiple reports using DoCmd.SendObject

[HomeGrowth]

I am able to send one signle report using DoCmd.SendObject as follow:

DoCmd.SendObject acSendReport, "rpt(2)DRTasksEmail", acFormatRTF, _
stTo, stCC, stBcc, Format(Date, "Medium Date") & " DR Status", "See Attached file!", _
True, False

Can DoCmd.SendObject send multiple reports? or I need look up some other methods. If there is one, can someone provide suggestions. Thanks!

 

[DoubleD]

SendObject is only able to send a single report.

There are several ways to send multiple reports.
1. Output each of the reports and put them all in a zip file. Then send the zip file.

2. Output each of the reports, then attach them all to a single email.

3. Cycle through sending each report as a separate email.


For options 1 and 2 you will need to be familiar with VBA code. And option 2 will depend on which email program you're using.

I am what I am based on the decisions I have made.

DoubleD