how do I combine two mailing lists and remove duplicates

E

Eye

how do I combine two mailing lists (from Excel) into Word and remove
duplicate entries between the two lists?
 
G

Graham Mayor

Save the two Excel tables as comma delimited (CSV) files. Import both to
Word. Sort the list alphabetically (Table > sort), then do a wildcard search
for
(*^13)@
Replace with
\1
to remove duplicates from the sorted list.
Then see
http://www.gmayor.com/convert_labels_into_mail_merge.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Top