Loop with Leban's code to merge 3+ reports to one PDF file

A

angie057

Joined
Jun 6, 2012
Messages
2
Reaction score
0
Hello,

I have successfully utilized Stephen Lebans's Merge to PDF code ( http://www.lebans.com/reporttopdf.htm ) to merge two pdf files. I have also successfully written a separate loop to output multiple pdf files to one folder (posted below).

Can anyone help me combine the loop and Stephen's merge function so I can combine all the pdf files to one?

Cheers,
Angie


For Each varItem In Me.lstEFCReport.ItemsSelected
rptName = Me.lstEFCReport.ItemData(varItem)
srn = Me.nbrServiceRequestNumber
DoCmd.OutputTo acOutputReport, Me.lstEFCReport.ItemData(varItem), acFormatPDF, "C:\\Folder\" & rptName & srn & ".pdf"
Next
 

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

Similar Threads

Create a seperate PDF Report for each company 1
Printing/Outputing to PDF File 1
Cross-database calls to DoCmd.OutputTo for PDF or XPS output fail. 3
Output to PDF creates incomplete report 6
How to merge existing PDf file in the same folder to one PDF file 2
Lebans Report to PDF 2
Merging RTF files into one RTF file 6
Output To PDF 10

Top