Exporting Access report to rich text format

P

Propp

How can I get my Access report - which has a different page for each
department - to export to rich text format files - one file per page - vs one
rtf file for the whole report?
 
B

Brian

Propp said:
How can I get my Access report - which has a different page for each
department - to export to rich text format files - one file per page - vs one
rtf file for the whole report?
Click to expand...

I think you will need to change your report to do one department at a time,
and write a little loop in VBA to run and export each one in turn.
 
T

Tony Toews

Propp said:
How can I get my Access report - which has a different page for each
department - to export to rich text format files - one file per page - vs one
rtf file for the whole report?
Click to expand...

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top