VB Script - Split Report PDF into mutiple files

Hi All!

I was wondering if there was a way to create a Macro in Access that will export your report into multiple PDF files with different names.

Example: I created a report that is designed to provide employees with a two page report on their progress. But when I go to Print Preview and under the Data tab, click PDF, it exports all 100 pages to the same PDF file (50 employees, 2 pages each).

I would like to create a script that runs a macro that tells it to create 50 different 2 page PDF exports and use the Employee Name as the beginning of the file name [Emp_Name]&" - Progress Report".

I know this may be a little complicated to put it all down in a forum, so if you could even point me to an article online to help me, that would be excellent.

Thanks all for you help!!

Hi All!

Its been a month since I posted this question, still have not found an answer, if anyone out there has any suggestions, it would be greatly helpful!

Thanks All!