Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Suppress Duplicates?
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? |
#2
|
|||
|
|||
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/Genera...gWildcards.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 "trayl" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress prompts when merging from excel datasource | Mailmerge | |||
How do you suppress a line in word if merge fld is blank? | Mailmerge | |||
how do I suppress word alerts? | Microsoft Word Help | |||
How do I suppress blank lines in a table in Word 2000? | Mailmerge | |||
How do I suppress blank address lines in Word2003 mail merge? | Mailmerge |