Exporting Access report to rich text format

[Guest]

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?

 

[Brian]

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?

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.

 

[Joseph Meehan]

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?

Maybe Publish it with Word?

 

[Brian]

Maybe Publish it with Word?

I think he knows how to do that. What he wants is each page in a separate
RTF file!

 

[Joseph Meehan]

I think he knows how to do that. What he wants is each page in a
separate RTF file!

Oh. Yea, that would be a bit more complex. I suppose if you can
specify the name for a file, you should be able to do that in VBA. It is an
area I have never worked in so I would not be a good one to give any advice
in this area. I have enough trouble in those areas I have worked in.

 

[Tony Toews]

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?

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