Help with Access -> Word Mail Merge

[Jim Meyer]

Hello!

I am doing my best to develop a database that automates
the generation of a series of Test Cases using the Mail
Merge feature of Microsoft Word to import information from
an Access Database.

I can get all the fields to fill out correctly from EXCEPT
for the fields that are Many to One.

For example, each Test Case has a list of Test Procedures,
numbered sequentially. In the Access Database this is
represented by two tables, of course, to represent the
Many to One relationship.

I have built a query to combine the tables into one data
source for Mail Merge.

Is it possible to create a Mail Merge function that will
append ALL the Procedure entries into the single Word
Document?

Thank you for your prompt and intelligent replies.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Jim,

Why not do it all in Access?

But, see the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm
--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Sharon]

I struggled and struggled and struggled with just this
issue! I am not an expert in Access and/or Word, but I
did it. I don't always use the terminology that is up-to-
date, but I got the job done. Feel free to e-mail me and
maybe I can explain how I did it. Thanks.