I have many individual snapshot reports (customer invoices) that I would like to concatenate/merge into one big report.

Does anyone have any code examples on how to do this?

I'm thinking that when the individual report is created...

        DoCmd.OpenReport REPORTNAME, acViewPreview
        outputFilename = "P" & Reports(REPORTNAME).Pages & "_" & outputFilename
        fileToSave = SAVEPATH & outputFilename
        DoCmd.OutputTo acOutputReport, REPORTNAME, acFormatRTF, fileToSave, False
...that another report (I'll called it the "merged report") would be opened and appended with the individual report.
If there is a better way, I am open to suggestions.

My other option is to somehow concatenate/merge the RTF files. Does anyone have any VBA examples of this?

Many Many Thanks, Gurus!