Exporting a Report to a Word Document

[Bhujanga]

I need to create word documents from an Access Report. Below is the code that I am using. It works but there are problems. The page breaks generated by the report don't always line up just right with where Word wants to break the page. So, sometimes I get one or two lines from the bottom of a page showing up at the top of a headerless page all by themselves. Then the Report page break comes and starts the next page with a header. So a 7-page report might have anywhere from 9 to 12 pages with the extra pages being mostly blank and headerless. I've tried fiddling with the top and bottom margins in the page layout, but it doesn't seem to help. Is there some way to avoid this dilemma?
Thanks.

Private Sub cmdCreateIt_Click()

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Dim stDocName As String
Dim Path As String
Path = DLookup("[Path]", "Region Data") & "\Region_" & DLookup("[Region]", "Region Data")
stDocName = "Selected Terms and Conditions"
DoCmd.OutputTo acReport, stDocName, _
acFormatRTF, Path & "\TCReports\" & Me![PermitNumber] & ".rtf", True

End Sub

[nico5038]

The export to a Word document from a report is having many issues.
Personally I never use it.
When I need Access data in a word document I revert to using the Mailmerge option from MS Word and use a "report query" to get the data from.

Nic;o)

[Bhujanga]

Thank you for the suggestion, however I'm not sure that it will work in this case. I use mailmerge for cases where various fields of data from the same record appear on the same page, but in this case it is selected records that appear sequentially on the page (or pages) with each records being sequentially numbered. So it looks like this:

{Header.......}

1. Legal mumbo jumbo from one of the selected records....
2. More legal mimbo jumbo from the next selected record....
3. Legal M.J.
4. Legal M.J.
.
.
.
37. Last bit of legal mumbo jumbo

See, what they do is check boxes in the library of the legal terms and conditions, then I have a query that selects only the records where the box is checked and those records appear in the detail section of the report. There is a counter in the detail definition to generate the numbers. Some of the individual terms and conditions can be several paragraphs long. Is this still possible using mail merge?

Thanks very much for any insight you might have.
P.S. Do you know if 2007 might improve the exporting problem at all?

[nico5038]

Hmm, then you'll need to use "automation" to manipulate the Word document from Access.
This link shows how to find a location in a Word document:
http://support.microsoft.com/kb/210032

For A2007 the "export" is made easier because of the use of SharePoint. This does however require a SharePoint Server or a subscription to a SharePoint service provider. (Will require $$'s)

Nic;o)