Exporting Reports to a Word Document

[bhujanga]

I need to export reports to a Word Documents so people can have a separate editable document file of contract conditions that are sent out. I am doing this by using this command:

DoCmd.OutputTo acReport, stDocName, _
acFormatRTF, Path & "\TCReports\" & Me![PermitNumber] & ".rtf", True
It works, but it hoses the format a little. It puts a random amount of extra space between paragraphs (which are detail sections). This causes the report page breaks to not align with the Word page breaks, which results in one or two orphan lines on headerless pages between the pages with headers. If I print pdfs directly from the report, it works perfectly, so it's definately some kind of bug in the RTF translater. Does anyone know how to avoid this, or have a better way to do it?
Thanks.

 

[Remou]

Reports to Word are problematical. It is possible to output HTML, which can be better, especially if you build the HTML yourself.

 

[JoeAtWork]

The only way to create the Word document exactly as you want would be to use automation to start a Word.Application object, and build the document line by line.

Needless to say, this would be a lot of coding.

 

[Remou]

JoeAtWork
I find that <P Class = "abc"> will relate to a Style 'abc', which means that you can do a great deal with HTML.

 

[Ravensleach]

I am struggling with this too and found this:

http://www.lebans.com/richtext.htm#ResizingCode

I haven't tried it yet because my client is thousands of miles away with no tech support on the spot, but I'd be interested to know if it can solve the problem in a non-distributed db