Print to PDF

[Rob Buonocore]

I have a report in Access. Its basically a mail merge. Each page is
the same report but for a different person. If there are 50 people in
the report, then the report is 50 pages long. I would like to "blast"
this to PDF. I would like to write code that creates a separate PDF
for each person and saves them with a set name to a set location.

Does anyone know of a way to do this?

Robby

 

[Tony Toews]

I have a report in Access. Its basically a mail merge. Each page is
the same report but for a different person. If there are 50 people in
the report, then the report is 50 pages long. I would like to "blast"
this to PDF. I would like to write code that creates a separate PDF
for each person and saves them with a set name to a set location.

The following should get you started. You will need some VBA code
experience.
Emailing a different report to each recipient
http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[Rob Buonocore]

Thanks. I'm really looking for some code that would allow me to print
to PDF. The looping part isn't really what I'm stuck on.

 

[Rob Parker]

Hi Rob,

You don't say which version of Acces you're using, but this implies that
it's pre A2007. If that's the case, try Stephen Lebans ReportToPDF solution
at http://www.lebans.com/reporttopdf.htm - I found it excellent for
precisely this sort of thing in Access 2003.

HTH,

Rob

 

[Tony Toews]

Thanks. I'm really looking for some code that would allow me to print
to PDF. The looping part isn't really what I'm stuck on.

One of the links on that page led to the following
Emailing reports as attachments from Microsoft Access
http://www.granite.ab.ca/access/email/reportsasattachments.htm. That
page in turn has a section on PDF files.

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/