Merge Letter

A

Angela

I am trying to merge a one to many query results into a letter. I want one
letter for each contact that contain all the report in formation in the
"many" table
 
V

Van T. Dinh

Word MailMerge is mainly for a "flat" database where data from each
Record/Row is merged into a separate letter.

If you want to include the data from the "Many" Record, you will need to use
Word automation code using the "One" Record for the Addressee Fields (in the
Word doc) and then fill a Word Table with data from "Many" Records. You
will need some loop structure in you code to traverse the "Many" Recordset
and fill the Word Table one row at a time.

Unless you are familiar with VBA (Automation)code and Word objects, the
Access Report is a much faster and easier alternative.
 
Top