How can I send two or more reports on the same e-mail in Access?

[Guest]

I have set up a macro to e-mail several reports however, they are all sending
on separate e-mails, is there a way to get them all to send on the same
e-mail?

 

[Steve Schapel]

Huliejews,

No, not directly. Not with a macro. There are two possible approaches.
One is to use a OutputTo action in the macro to save the first report
to a file on disk, than a SendObject action for the second report. Set
the Edit Message argument of the SendObject action to Yes, and then when
your email program opens, with the second report already attached, you
can manually attach the first report before sending. The other approach
is to place the two reports onto a blank unbound report as subreports,
with a page break between them. That means in fact you are only sending
one report, but the recipient can view or print it off and it will be
the same as if it was two separate reports.