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...
...that another report (I'll called it the "merged report") would be opened and appended with the individual report.
DoCmd.OpenReport REPORTNAME, acViewPreview
outputFilename = "P" & Reports(REPORTNAME).Pages & "_" & outputFilename
fileToSave = SAVEPATH & outputFilename
DoCmd.OutputTo acOutputReport, REPORTNAME, acFormatRTF, fileToSave, False
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!