how do I omit a duplicate field in a merged document?
 

I want to merge a list from Excel to a Mail Merge in Word. It works, but
there are fields that are duplicates in Excel that I do not want in Word.
For example, Mr. Smith has two lines of information in Excel which generages
two letters in Word. Is there a way to eliminate this?

You could add a column in which you count the occurrences of each entry.
For example, if you have a customer number in column A, enter the
following formula in row 2, and copy down to the last row of data:

=COUNTIF($A$1:A2,A2)

When merging in Word, filter this column for rows with a 1.

dawnlin wrote:
I want to merge a list from Excel to a Mail Merge in Word. It works, but
there are fields that are duplicates in Excel that I do not want in Word.
For example, Mr. Smith has two lines of information in Excel which generages
two letters in Word. Is there a way to eliminate this?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html