Automate printing of report

[pwomack]

I have a 77 page report. One page per customer that gets emailed to the customer.

What I do now is print each page individually to a pdf file using a pdf printer driver. So there are 77 pdf files.

This is time consuming for me. Does anyone know of a way to automate the printing of the 77 pdf files?

Thanks.

 

[dhookom]

Would Stephen Leban's utility provide the functionality you need?

Duane
Hook'D on Access
MS Access MVP

 

[Dontremb]

Is there a specific reason that you have to send it in PDF form?

 

[ProgramError]

You can email directly without having to convert them. As Dontremb says, do you really need to convert them to PDF files firstly???


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.