how to export access 2010 report to ms word

[rahul2310]

I have created joining letter in access 2010,as it is a letter it is not in column and row format.
When i export report to word it does not shows report instead it shows column headings and data below it.
what will be the code to export entire report in ms word as it is in access on button click.
thank you

[topher23]

When you export from Access, you are always exporting data. This is why you are getting data (columns and rows) when you try to export from your report. What you want isn't an export of data but an output of your object with the selected data. Based on the little you've provided, I'd suggest creating an RTF output using:

DoCmd.OutputTo acOutputReport, Me.Name, acFormatRTF, "Your\Desired\Filepath.rtf"

If that doesn't look right, try doing a PDF output:

DoCmd.OutputTo acOutputReport, Me.Name, acFormatPDF, "Your\Desired\Filepath.pdf"

Then use a third-party converter to turn your PDF into a Word document.

[rahul2310]

thanks topher it works well

[zmbd]

Yes, this is a known hiccup in the export report to word method for ACC2010. Drives me nuts! You have this great report with all the lines and grouping etc... and then Microsoft really messed things up by not exporting the pretty report like they used to do...

Both Topher23 suggestions are very workable. The PDF will give you the report as you have it in Access where as the RichText may still require some serious tweeking.

If you need somthing a little different then you have the MailMerge feature in Word. This can use the information within Access.
Here is a basic example from Microsoft - Use a table or query as a mail-merge data source

Then there is Application Automation... it is not for the faint of heart and I wouldn't consider it unless Topher23's suggestions or the Mailmerge fail to meet your needs.