Grouping data in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zufhaus - 10 Jul 2006 22:31 GMT

i have a spreadhseet with multiples lines of data for each of john doe, sue
doe, and bill doe. i want to merge a letter to each of them, but the merge
wants to make a new letter for each line of john bill and sue doe, instead of
grouping all the john entries into one letter, etc. any idea how to get the
merge to create a new letter for each change in addressee, instead of one
letter per line of data? thanks!

Reply to this Message

Peter Jamieson - 11 Jul 2006 09:15 GMT

Word isn't designed to do this - if possible, use a Report generator
designed to do it (e.g. the one in Access).

Or try e.g.

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

and/or

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

Peter Jamieson

>i have a spreadhseet with multiples lines of data for each of john doe, sue
> doe, and bill doe. i want to merge a letter to each of them, but the
[quoted text clipped - 5 lines]
> merge to create a new letter for each change in addressee, instead of one
> letter per line of data? thanks!

Reply to this Message