I merged a few email lists and want to remove duplicates. How?

  • Thread starter Thread starter DFDietrich
  • Start date Start date
D

DFDietrich

I have scores of emails within a WORD document, separated by commas, but in
no particular order. Since I merged a few lists together how can I
effectively search through the list for duplicates and remove them?
 
I would convert that text to a single column table, paste that in Excel,
then use ASAP Utilities to lok for duplicates. But that's just how I would
do it.
 
Emails? Do you mean email addresses? In that case use replace to replace
, with ^p
Then sort the column and use replace to replace
(*^13)@
with
\1
with the wildcard option set to remove duplicates.
See http://www.gmayor.com/replace_using_wildcards.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get selected word documents from user's choice and merge those documents as a single doc file 0
create a list of duplicated items in text file 4
Combine documents, merge changes & eliminate duplicates 1
How do I remove a comma after company name in mail merge address. 3
Email Merge Outlook Settings 1
Word 2007 Mail Merge / Directory & Section Breaks 2
How can I review a Word document for duplicate sentences? 1
Duplicate Remover 8

Back
Top