Reply
 
Thread Tools Display Modes
  #1   Report Post  
trayl
 
Posts: n/a
Default 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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppress prompts when merging from excel datasource Dorothy Mailmerge 2 July 22nd 05 12:46 PM
How do you suppress a line in word if merge fld is blank? Todd Mailmerge 6 July 21st 05 06:22 AM
how do I suppress word alerts? don Microsoft Word Help 1 June 29th 05 01:33 AM
How do I suppress blank lines in a table in Word 2000? mauitom Mailmerge 1 June 24th 05 09:00 AM
How do I suppress blank address lines in Word2003 mail merge? JonUK5691 Mailmerge 1 March 22nd 05 09:31 PM


All times are GMT +1. The time now is 01:47 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"