How do I merge several entries in one column with only one in anot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janet - 28 Aug 2006 17:40 GMT

We have data in Excel with name and address in one column and several loan
numbers in another column. Some people have several loan numbers assigned to
their name and I want to have one letter with one name and address and all of
the customer's pertinant loan numbers.

How can I do this? Right now of course when I merge it makes a seperate
letter for each loan number. Any help is appreciated, thank you!
jb

Reply to this Message

Doug Robbins - Word MVP - 28 Aug 2006 18:15 GMT

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

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

Or take a look at the following Knowledge Base Article

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

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

Signature

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

> We have data in Excel with name and address in one column and several loan
> numbers in another column. Some people have several loan numbers assigned
[quoted text clipped - 6 lines]
> letter for each loan number. Any help is appreciated, thank you!
> jb

Reply to this Message

Rate this thread: