Report Needs to Print Out Separately to PDFs with Naming Convention

[julieh]

I have a 900 record file. I created a report to display each record's info. I now need to print out separate PDFs for each record. I also need to name each record with information in several fields in the file. I downloaded Bullzip. This is what I have so far.

I have been messing with these 2 statements to get Access to export these pages as separate pages. One does ½ of what I need and the other does the other ½, but I can’t get them to work together:

DoCmd.OutputTo acOutputReport, "", acFormatPDF, "dealership call report.pdf": This does the PDF part.

DoCmd.PrintOut acPages, x, x: This prints the 1 page at a time, but it references bullzip (free pdf creator) instead of Adobe. Bullzip prompts each time it prints for the user to enter a filename.

 

[jrbarnett]

The Bullzip PDF printer driver (even the free one) is customisable, you can configure it to output to a specific folder using a defined naming convention.

Can I suggest that you read the documentation that comes with BullZip, starting with the Documentation link in the start menu program group.
You can then configure global or per user settings as you need to fit your requirements.
To give you a head start the output filename is configured in the output= line in your settings ini file.

John