How do I export multiple reports

[Guest]

I need to export multiple reports in rich text format. I can do this in
snapshot (snp) format, but can't figure out how to do it in rich text. I am
not an experienced Access user, so I need something that I can understand. I
have figured out how to do this using a macro and OutputTo, but that is only
doing 1 report at a time and I have 8 reports that I would like to do at
once. Any suggestions?

Thanks.

 

[Guest]

Hi,
try to adapt VBA (visual basic for applications). Macros are very limited
and cannot handle error handling. Therfor you can use vba on the on click
event of a button on a form with some code which just repeats several
outputto commands e.g.:

DoCmd.OutputTo acOutputReport,"ReportName", acFormatRTF,"c:\path to
file\file.rtf", False
DoCmd.OutputTo acOutputReport,"ReportName01", acFormatRTF,"c:\path to
file\file01.rtf", False
DoCmd.OutputTo acOutputReport,"ReportName02", acFormatRTF,"c:\path to
file\file02.rtf", False
....
HTH
Good luck