CODEWITHSUNDEEP
ms-accessms-access-2010
Charlie
Charlie

Reputation: 1179

Access report export to a word file

Is it possible to export an access report to a .docx file?

At the moment we export only .pdf but also need the word document

Upvotes: 1

Views: 10530

Answers (2)

Huntdogg
Huntdogg

Reputation: 195

If you have the pdf open with Adobe Acrobat, you can simply save as a Word file.

File > Save as > Microsoft Word > Word Document

The same goes for Microsoft Word if you decide to export it as a RTF file and still want to convert to .doc or .docx.

File > Save as > Word Document

VBA Route: Exporting a report to word format (.doc & docx) are not supported in the Docmd.OutputTo. However there looks like there is a method that will work the way you want it to found here: Exporting MS access Report to MS Word using VBA

Upvotes: 0

user5818624
user5818624

Reputation:

This can easily be accomplished with the Docmd.OutputTo method.

Here is a link to the formal documentation: https://msdn.microsoft.com/en-us/library/office/ff192065.aspx

Here is a one-line example of how I would do it:

Docmd.OutputTo acOutputReport, "rptMyReport", acFormatRTF, "C:\Users\User\Documents\MyExportedReport.rtf"

However, while this method can export it as an rtf (which can be opened in Word), it can't do it as a docx. Does this report need to be converted to that docx format? If so, a little more complicated procedure may need to be involved to accomplish this.

Upvotes: 2

Related Questions