Combining Multiple Reports into one pdf file

[linskill]

Hi Chaps,
I am using a the below code to print off reports - is there anyway to combine these reports into one pdf file?

Private Sub Command22_Click()
On Error GoTo ErrProc
DoCmd.OpenReport "FinancialReport", acViewPreview, , "AppointmentT.ApptID=" & ApptID
DoCmd.OutputTo acOutputReport, "FinancialReport", acFormatPDF, "C:\Clients\Financial.pdf"
DoCmd.Close acReport, "FinancialReport", acSaveNo

DoCmd.OpenReport "HealthReport", acViewPreview, , "HealthT.ApptID=" & Me.ApptID
DoCmd.OutputTo acOutputReport, "HealthReport", acFormatPDF, "C:\Clients\HealthReport.pdf"
DoCmd.Close acReport, "HealthReport", acSaveNo

DoCmd.OpenReport "HelpReport", acViewPreview, , "helpT.ApptID=" & Me.ApptID
DoCmd.OutputTo acOutputReport, "HelpReport", acFormatPDF, "C:\Clients\HelpReport.pdf"
DoCmd.Close acReport, "HelpReport", acSaveNo

DoCmd.OpenReport "PersonalReport", acViewPreview, , "ResillienceT.ApptID=" & Me.ApptID
DoCmd.OutputTo acOutputReport, "PersonalReport", acFormatPDF, "C:\Clients\PersonalReport.pdf"
DoCmd.Close acReport, "PersonalReport", acSaveNo

DoCmd.OpenReport "SelfEsteemReport", acViewPreview, , "SelfesteemT.ApptID=" & Me.ApptID
DoCmd.OutputTo acOutputReport, "SelfEsteemReport", acFormatPDF, "C:\Clients\SelfEsteemReport.pdf"
DoCmd.Close acReport, "SelfEsteemReport", acSaveNo

DoCmd.OpenReport "SocialReport", acViewPreview, , "SocialT.ApptID=" & Me.ApptID
DoCmd.OutputTo acOutputReport, "SocialReport", acFormatPDF, "C:\Clients\SocialReport.pdf"
DoCmd.Close acReport, "SocialReport", acSaveNo

DoCmd.OpenReport "WellbeingReport", acViewPreview, , "WellbeingT.ApptID=" & Me.ApptID
DoCmd.OutputTo acOutputReport, "WellbeingReport", acFormatPDF, "C:\Clients\WellbeingReport.pdf"
DoCmd.Close acReport, "WellbeingReport", acSaveNo
ExitProc:
    Exit Sub
ErrProc:
    Select Case Err.Number
        Case 2501
            Resume Next
        Case Else
            MsgBox Err.Number & " -- " & Err.Description
    End Select
    Resume ExitProc

End Sub

 

[cheekybuddha]

Is this just a continuation of this thread?

 

[ebs17]

Solved - Export to PDF and Merge Another PDF

Hi All, Is there a way of exporting to PDF and then merging another PDF file to my report? I have a code that exports my report to PDF then attaches it to an email. What I would like to do now is export it, merge it, then email the combined file. Is this possible? ~Matt

www.access-programmers.co.uk

Or you put your reports together as sub-reports in a gas office report and create the PDF from them.

 

[linskill]

Is this just a continuation of this thread?

Possibly, same database, different subject. Mod's would you please move it to the existing thread if you think its appropriate.

 

[Gasman]

Have a look at this thread?

Solved - Export to PDF and Merge Another PDF

Hi All, Is there a way of exporting to PDF and then merging another PDF file to my report? I have a code that exports my report to PDF then attaches it to an email. What I would like to do now is export it, merge it, then email the combined file. Is this possible? ~Matt

www.access-programmers.co.uk

 

[CJ_London]

see these links

Solved - Export to PDF and Merge Another PDF

Hi All, Is there a way of exporting to PDF and then merging another PDF file to my report? I have a code that exports my report to PDF then attaches it to an email. What I would like to do now is export it, merge it, then email the combined file. Is this possible? ~Matt

www.access-programmers.co.uk

Solved - Tool for combining PDFs

Does anyone know of an inexpensive tool that can be used to combine multiple PDFs into a single PDF through VBA without having Adobe Acrobat?

www.access-programmers.co.uk