I was recently shown a new utility that allows you to burst reports into sections and e-mail each section as a separate PDF attachment to a different Email address. The tool is called PDF-eXPLODE and it makes bursting and Emailing your reports as simple as printing them.
Say you have a report that prints 30 invoices and each invoice should be Emailed to a different person. All you do is put the Email Address at the top of each page (invisibly if you want), and then “print” the document to the PDF-eXPLODE virtual printer. This printer is installed automatically by the program. When you “print” to this printer it automatically bursts your report into separate PDFs for each Email Address and then sends out the PDFs as attachments to the messages. If one Email address shows up at the top of several pages (even non-consecutive pages) those pages will be combined into one PDF and sent. It even works with other document types like Word docs or MS Access reports.
Of course the best way to see what it does is to test it. You can download a free trial copy and try it for 30 days. The purchase price is $349 per user. Read more on the Details page.