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
 
Back
Top