Formatting problems when outputting a report to Word in RTF

[asawhill]

I have a report based on a table of suppliers that needs to be exported to Word so it can be e-mailed later on. The report is a 3-page letter to each supplier with certain fields like supplier name and date changing based on the information in the underlying table. When the report is run, a separate 3-page letter is generated for each supplier.

My problem is when the letters are exported to Word, some formating problems occur - specifically a portion of the text from page 1 of the letter winds up at the top of page 2, and messes up the rest of the formatting. This is very confusing because it's not a whole text box that is being moved, but just a few words of text from within the text box itself. I'm at a loss on how to correct this. Any suggestions? Thanks for the help!

 

[asawhill]

Ammendment to above: the text error is originating from a label box, not a text box. Sorry for the confusion - just want to get my vocabulary straight.

 

[Norie]

Why don't you Mail Merge from Word with the query/table the report is based on as the data source?

That would give you far more control over the formatting of your letters.

 

[asawhill]

Sounds like a good idea. Part of this letter contains a subreport from a different table. Is it possible to use the Mail Merge feature with multiple data sources?