word/access mail merge

[Guest]

I am trying to print letters in word that use access data to fill in merged
fields. In these letters I am asking Farmers to verify the counties that
they are farming utilizing the list of counties that they farmed in 2006 from
my access database. The counties that they farmed are listed relationally in
the data base by their corresponding tax id number. If a farmer farmed in
four counties in 2006, Word will print 4 letters, one with each county
instead of grouping the 4 counties into one letter. The only way I know now
to perform this is to convert my relational table of counties farmed to a
flat file. I just have to believe there is a better way around this.

 

[Albert D. Kallal]

The built in word merge only takes one record for each whole docuemnt.

The real part that not been cracked is how to have users specify what child
reocrds to include, what fields and how to design and layout the "table" of
many records that you need.

So, the problem is there is no built in provisions for the "many" side of
relational data, and thus the only approach is to write code that actually
inserts the child data.

there are some examples of how to do this here:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

look on the left side for special merges. The one you want is
Multiple items per condition