Link to home
Start Free TrialLog in
Avatar of newbie46
newbie46

asked on

Can Access 2007 export a report to Word and save it in a 'prior to 2007' format?

I have a command button on an Access 2007 form which exports a report to Word. Is it possible, through VBA, to export the report and have it saved in a format compatible with older versions of Word?
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

If you specify a .doc file that should be sufficient.
Please post the code you are using now.
Avatar of newbie46
newbie46

ASKER

matthewspatrick,
DoCmd.OutputTo acOutputReport, "rptA", acFormatRTF, PMTableName & ".rtf", True
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks.
Personally, I avoid the RTF export as well, since it embeds hard carrage returns and has other formatting issues.

If I want my output to go to Word, I generally write a custom procedure that opens Word via automation, and I build the Word document from scratch.  I could post some sample code (if you are interested), it wouldn't mean much because all the tables and fields are meaningless, but it might give you some ideas regarding how to do this.