Mail Merge

[Cees Spillekom]

When doing mail merge with an exelfile and a word document. Mail merge
will generate a letter for each line in the exelfile.

When I want to do a mail merge with an exel file containing f.i.

Customer product
smith cherry 1
smith berry 1

How do I get mailmerge to create only 1 leterfor Smith with both
products instead of 2 letters, each letter for 1 line.

Thanks

 

[Cindy M -WordMVP-]

Hi Cees,

Word doesn't do this easily. You'll find a discussion in the special
merges section of my website's mail merge FAQ about how to do
"one-to-many". There are links to sample files; I recommend the DATABASE
field approach, if you can display the list in a table.

When doing mail merge with an exelfile and a word document. Mail merge
will generate a letter for each line in the exelfile.

When I want to do a mail merge with an exel file containing f.i.

Customer product
smith cherry 1
smith berry 1

How do I get mailmerge to create only 1 leterfor Smith with both
products instead of 2 letters, each letter for 1 line.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail