Suppress Duplicates?

[trayl]

does anyone know how to suppress duplicate records in a mail merge. i am
merging from an Access database table that has several duplicate records - is
there any way of getting Word to not include any duplicates it finds when
creating the mail merge?

 

[Doug Robbins]

Access has a Wizard to create a query that will find duplicates in a table.
Why don't you use that. Access is far better at data manipulation than
Word.

An alternative would be to Move the data into a Word table using copy and
paste and then you will find a method of removing duplicates in the article
"Finding and replacing characters using wildcards" at:

http://www.word.mvps.org/FAQs/General/UsingWildcards.htm

You can then use that document as the datasource.
--
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