Access Report Printing (1 Viewer)

[Zippyfrog]

Is there a way in Access that when I print a report to PDF that every page can be a separate PDF file? My scenario is I have 30 pages for 30 different people, each person getting one page that is personalized to their data. Instead of me printing to a PDF then having to manually create 30 PDF's, or printing one page at a time to a PDF, is there a script that when I print to a PDF would create 30 different files where each file name is the unique identifier for that person? Or where I could customize the file name to be ID - LastName, FirstName.pdf?

 

[gemma-the-husky]

You would need to call the report 30 times

generally extract a query with all the recipients, or even use an array.

Then this sort of pseudocode

for each recipient
    set variables to manage the report for the active recipient
    print the report/pdf
next recipient

 

[Pat Hartman]

The loop shown by gemma will typically be reading through a query that selects the individuals and uses the name from the table to name the report file..