Leon.Kennedy
July 21st, 2008, 10:15 AM
I am stuck on something and am in need of a little help. I am using the SendObject command to send a report (in snapshot format) to a few email recipients. I have multiple reports that need to be sent via email.
My problem here is that I have to use the SendObject command for each report that I need to send. Does anyone know of a way to pipe the Object portion of the command so that all reports that need to be sent are attached to one email?
I searched on the internet and am unable to find any usage that shows how to send multiple reports as attachments to one email. I know that I could use the OutputTo command for each report, and then attach them all individually to one email, but this takes even longer.
If anyone can help, I would truly appreciate it.
EDIT: Here is the code I have for the SendObject command.
DoCmd.SendObject acSendReport, report name, acFormatSNP, , , , report title, , -1
My problem here is that I have to use the SendObject command for each report that I need to send. Does anyone know of a way to pipe the Object portion of the command so that all reports that need to be sent are attached to one email?
I searched on the internet and am unable to find any usage that shows how to send multiple reports as attachments to one email. I know that I could use the OutputTo command for each report, and then attach them all individually to one email, but this takes even longer.
If anyone can help, I would truly appreciate it.
EDIT: Here is the code I have for the SendObject command.
DoCmd.SendObject acSendReport, report name, acFormatSNP, , , , report title, , -1