Saving report as document

[John]

Hi

How can I save output of a report to disk as a word document via code?

Many Thanks

Regards

 

[Allen Browne]

How can I save output of a report to disk as a word document via code?

Use the OutputTo action (in a macro) or method (in VBA code.)

Choose Rich Text as the format. It saves in RTF format, which Word can open.

Note that RTF loses graphical elements (e.g. logo, lines, check boxes.) You
can get lines by using the underscore character in a label. You can get
check boxes with a Wingdings character in a text box. Details:
Format Check boxes on reports
at:
http://allenbrowne.com/ser-52.html

 

[Daniel]

Use the DoCmd.OutputTo command using the rtf format.

Example:
DoCmd.OutputTo acReport, "rptGLTable", "RichTextFormat(*.rtf)",
"C:\GLTable.rtf", False

 

[John]

Can I use C:\GLTable.DOC will it still work?

Thanks guys

Regards

 

[Allen Browne]

No. Use the RTF extension.

By default, RTFs open in Word when double-clicked.