How best to do this depends upon the datasource. If it is a table in an
Access database, it is very easy to do using a query.

If, it's in Excel, it can be done, using and IF() function construction and
then doing a sort.

If it's in Word, you will find some information of eliminating duplicates in
the article "Finding and replacing characters using wildcards" at:

http://www.word.mvps.org/FAQs/Genera...gWildcards.htm


--
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

"dan" wrote in message
. ..
Hello listers

I saw your code on the cindy meister website regarding suppressing
duplicates in a mail merge. I unfortaunately am not able to follow it very
well.

I have a data source with a bunch of fields. I only need 2 of the fields
in
my mail merge document. When I merge them to my template I get lots of
multiples when I really need only one of each.

I am making labels for pricing items and have the following data source
model

itemnumber itemprice itemdescription itemmodel
1234 24.95 item1yellow 2
1234 24.95 item1gree 3
1234 24.95 item1blue 4
1234 24.95 item1red 5
4321 32.95 item1yellow 1
4321 32.95 item1orange 1

etc

but when i run a mail merge to make the labels i only need the item number
and the price since they are all the same. But running a normal mail merge
gives me 5 labels for item 1234 and two labels for 4321 when i really only
need two labels total as there are only two different item numbers.

If you could help me work through this or offer any code as to how to
accomplish this it would be greatly appreciated.

Altering the data source is not an option.

Thanks in advance!!!