Export Ms Access report to Ms word

[Sokkheng]

How i can export ms access report to ms word document with specific file name (mean I want to put file name with my customer ID).
Thanks

 

[theDBguy]

Do you mean manually or using code?

 

[Sokkheng]

Do you mean manually or using code?

With code for user click on bin

 

[onur_can]

You can transfer it with a command like this.

DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF, customerID & "ReportName"

 

[isladogs]

As already stated, exporting reports as .RTF is rarely satisfactory. I would just use .PDF output.
However, another possible approach to get a Word doc of the report is to export to PDF using code as provided in #3, then opening that in Word and saving as .DOCX.
Results will not be perfect but may be closer than the .rtf output.