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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Top