Access report print each page to separate PDF file
I have the same problem as following describe:
"I work for a bank owned by a bank holding corporation with 35+ banks and 280+ branches in 5 states.
With that said, we do have the Acrobat Distiller on our computers. And I'm wondering if it is possible, with VBA, to take the 40+ reports I have to generate from Access each month and print each page of the reports to a separate PDF file? I want to be able to specify the report name and location in the VBA code, rather than typing it in for each page of each report. These reports are sales incentive reports for loan officers, and each page of the reports has a field that contains the officer names. It would be wonderful to be able to use the contents of that field from each page as part of the file name."
Can someone help?! Thanks