Merging Similar Records

[Jen]

I'm hoping someone can help. A coworker has a database listing people and
the parcels of land they own. Most people only own one parcel, so the merge
is easy. Other people own multiple parcels and thus have multiple records.
For example:

Jane Doe 990.11.00
Jeff Dean 870.24.6
John Smith 109.1.08
John Smith 203.12.7
John Smith 221.13.1

When we do a normal merge, it creates three (3) letters for John Smith. Is
there a way to say "If John Smith has more than one of "X" (i.e. parcel
numbers), list the next parcel number. Basically we want the letter to show
the following:

John Smith
109.1.08
203.12.7
221.13.1

Is there a way to do this? I was thinking of using a condition, but can't
figure out how that would work, either.

Thank you in advance!

 

[Doug Robbins - Word MVP]

To see how to do this, take a look at:
http://cornell.veplan.net/article.aspx?&a=3815

or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP