attaching 2 or more reports in 1 email message

[Heidikf]

Hi, I am trying to figure out how to run 3 reports and attached them to
one email using a macro. I can only get 1 report per email message.
Help! Thank you!

[Ira Solomon]

Hi:

You have to be sneaky. The underlying command only allows a single
attachment so you can't just list 3 reports. You could send 3 emails,
but you don't want to do that.

Create an empty report and embed your 3 reports as subreports.

Then you can send you new report which includes the three reports you
wish to use. Place a pagebreak control between the subreports.

Good luck
Ira Solomon