Can you export a report to word97?

[arage]

Can an access97 report be exported to word97? When I do the export function on access, word is not one of the options to export to in my drop down list.

 

[Talismanic]

.RTF (Rich Text Format) is usually associated with Word so if you select that from the drop down list, Word should open your reports.



[This message has been edited by Talismanic (edited 07-12-2001).]

 

[Talismanic]

To do this in VBA the code would look like this:

DoCmd.SendObject acReport, "ReportName", "RichTextFormat(*.rtf)", _
"EmailAddress", , , "OptionalSubject", "OptionalText", False

 

[The_Doc_Man]

Exporting in this way loses lots of formatting information because the .RTF format doesn't support as much as you might like. At my shop we approached this problem from the other direction; it worked better this way.

Instead of exporting Access data to Word, turn the problem around. Build a query, then build a MailMerge template (probably in catalog mode). For simple reports that don't have too many headers and footers, this might be more helpful. And you can define your formatting pretty well if you wish, keeping lines, boxes, bold, funky fonts, and other stuff like that.

I offered that as an alternative just because it is a bit "out of the box" - but it shows another way to skin that cat.