I am using the following stmt to export an Access report to Word. Whether I use acFormatRTF or acFormatHTML, I get the same error 'Microsoft Office Access can't save the output data to the file you've selected'
DoCmd.OutputTo acOutputReport, "rptTemplateFinal", acFormatRTF, _
"C:\Final Letter.rtf", True
The report that I am exporting has many controls which grow/shrink and the export needs to be editable. I have read in others posts that it may be best to export to HTML to avoid having text truncated?
What is the problem with the above stmt?