Hello,
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...
Code:
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!
L.