Emailing Multiple Reports

[David Dowdell]

I've got several reports that I would like to automate mailings. However,
only one snapshot will e-mail at a time. Combining the reports won't work
because some reports are landscape and some are portrait (there are also
other issues with combining). Does anyone know of a way to e-mail multiple
reports within the same e-mail message?

Thanks,
David

 

[Rick Brandt]

I've got several reports that I would like to automate mailings. However,
only one snapshot will e-mail at a time. Combining the reports won't work
because some reports are landscape and some are portrait (there are also
other issues with combining). Does anyone know of a way to e-mail multiple
reports within the same e-mail message?

You would have to automate an external mail library like Outlook or CDO. Then
you can output your reports to disk and generate an email with as many
attachments as you want. SendObject just won't do this. Example code at link
below.


http://www.mvps.org/access/modules/mdl0019.htm

 

[David Dowdell]

I've got several reports that I would like to automate mailings. However,
only one snapshot will e-mail at a time. Combining the reports won't work
because some reports are landscape and some are portrait (there are also
other issues with combining). Does anyone know of a way to e-mail multiple
reports within the same e-mail message?

You would have to automate an external mail library like Outlook or CDO.
Then
you can output your reports to disk and generate an email with as many
attachments as you want. SendObject just won't do this. Example code at
link
below.


http://www.mvps.org/access/modules/mdl0019.htm



--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Thank you, I will give it a try.

 

[Geoff Starr]

It worked perfectly! Thank you for your help.

David

I've got several reports that I would like to automate mailings. However,
only one snapshot will e-mail at a time. Combining the reports won't work
because some reports are landscape and some are portrait (there are also
other issues with combining). Does anyone know of a way to e-mail multiple
reports within the same e-mail message?

You would have to automate an external mail library like Outlook or CDO.
Then
you can output your reports to disk and generate an email with as many
attachments as you want. SendObject just won't do this. Example code at
link
below.


http://www.mvps.org/access/modules/mdl0019.htm