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!

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

On 14 Mar 2005 23:40:57 -0800, "Heidikf" <heidikf (AT) gmail (DOT) com> wrote: