combine multiple reports to one PDF

  • Thread starter Thread starter Ralph
  • Start date Start date
R

Ralph

I have 20 reports and a macro that sends them all to a printer. Is there a
way to send the 20 reports to one PDF? We get 20 PDFs and then have to
combine them and I'd like a way to skip this step and just make a single PDF
that includes all 20 reports in the correct order (pages 1 - 20). Access 2003
 
One other issue. The PDF maker prompts for the file location to save the PDF
which would be great to be able to set to a default and thus buzz right
through all 20 reports without have to click okay each time.
 
Ralph,

Mine does not because I specified a path ("c:\FolderName" &
Me.DocumentNameFromComboBox & ".pdf") Perhaps you didn't enter where to save
it... Please copy/paste the line here.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top