Mass emailing of snapshot reports

[mwheads]

Hi All

Does anybody have any idea how to send each page of a report (as a snapshot attachment) to bulk email recipients.

I have a report of 500+ pages (1 page per client), each with an individual report and specific email address, and I would like to send all in one routine.

Is anybody familiar with such a routine?

regards,

 

[JerryKlmns]

Create a recordset to grab the recipients (a loop till .EOF)
and use SendObject method for the report which runs for this recipient.

 

[SeeThru]

I've got something like this going.

Got a table with the filter for the report and the email address of recipient.

In code, open report, filtering with the filter, send as snapshot, close report, move to next record in recipients table, open report..etc, etc