access report bursting and email

[bradharlow]

Is there code that will allow me to send a store their single page of a 250 page report?

I need to be able to break a large report down to each page and send the pages to different email address. With our AS400 software this process is called report bursting.

Any ideas would be greatly appreciated.

 

[llkhoutx]

Generate your report (in some kind of loop) such that each page is a different report.

 

[Jbungie]

Sending Rep Reports

Hi,

I did a search and figured I would pick up where this thread left off. I need to send about 400 different reports in snapshot form to 400 different reps. Is there an easy way to do this via VB?

Thanks!!

 

[pbaldy]

Is it the same report, filtered for each rep?

 

[Jbungie]

Yep!

Thanks for responding

 

[pbaldy]

If you already have the report and its query contains a criteria for the rep (referring to a form), you can do this:

1) Open a recordset that obtains the rep ID and email address
2) start a loop based on that recordset
3) copy the rep ID to the form field
4) use SendObject to send the report, getting the email address for the current rep from the recordset.