Open a Word File after Export (Access 2000)

Topic

New Reply

I have a report I export as a rtf file. Is there any way I can automatically have the report open in Word AFTER I export it?

Thanks.

Reply | Quote

Replies

I’m not sure how you’re exporting your report, but if you’re using the OutputTo method, check out the AutoStart argument. The below line of code exports my report named “Rpt” to a Rich Text Format document named “MyReport.rtf” at the root of my D partition. The True value as the 5th argument is what tells the OS to fire up the application associated with .rtf files. Best of luck!

DoCmd.OutputTo acReport, "rpt", "RichTextFormat(*.rtf)", "D:MyReport.rtf", True, "", 0

Reply | Quote