Mail Merge - Grouping/Sorts

[oldladyonhill]

I want to do a mail merge, but have the results grouped (similar to a
report). For example, I want to do a single letter to each mailing
address, but within the body of the letter list all the donations that
person has made to our society.

I can get the merge to happen (Access to Word), but it generates a new
letter for each donation -- instead of a single letter with grouping of
records associated with that address. I've read, re-read, and re-read
again the mail merge sections of my manual and still cannot untangle
this.

My gray hairs are multiplying at an alarming rate, as I have thousands
of these to do. Anyone with suggestions or the answer?

 

[Peter Jamieson]

Word isn't really geared for this kind of thing - since you are using
Access,
for example, you should be able to do what you need using the Access report
designer.

However, to attempt it in Word, see the following articles:

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Peter Jamieson