Emailing Multiple Reports

  • Thread starter Thread starter David Dowdell
  • Start date Start date
D

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
 
David Dowdell said:
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?
Click to expand...

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 said:
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?
Click to expand...

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.
 
Back
Top