Steve:

There is a really neat product called Visual Cut from Millet Software .

It can pick up fields in a report and "split" the report into multiple PDF files based on that field. It can also automatically email the separate reports to an email address picked up from the report. (It must be in Group 1 and can be suppressed.)

The author, Ido Millet, is at Penn State University and is very helpful.