I have a pdf file, typically 200-250 pages long. It was created using Crystal Reports 9.0, pulling data from a sql2005 database. The document was printed to 'cutepdf'. It contains statements for about 100 agencies. Each agency's statement is between 1 and 15 pages long.

Our finance department wants me to automagically split this 1 file into 100 individual files, one file for each agency, so they can email them out monthly.

Each page has a page counter in the footer: Page 1 of 1, or Page 1 of 2, etc...

Is there a way to loop thru the pdf file, search for each instance of 'Page 1', start a new document/print job (which would be directed to the pdf writer) supplying it a name also derived from the pdf document (i.e. agency name).

Anyhelp is greatly appreciated.

Steve