Email multiple reports

B

Brett

Hello,
I have a database where I need to send one email with several reports in it.
Is there vb code to do that?
 
T

Tom van Stiphout

On Fri, 16 Nov 2007 05:32:01 -0800, Brett

Nothing built-in. DoCmd.SendObject can only send one report at a time.
So you need to first save the reports (e.g. to PDF files), then create
an email with multiple attachments. If you use Google, I'm sure you
can locate some sample code.

-Tom.
 
Top