how do I combine two mailing lists and remove duplicates Eye 4/28/2007 11:12:00 PM how do I combine two mailing lists (from Excel) into Word and remove duplicate entries between the two lists?

Re: how do I combine two mailing lists and remove duplicates "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 4/29/2007 1:22:14 PM 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)[ at ] 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 My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Eye wrote: [Quoted Text] > how do I combine two mailing lists (from Excel) into Word and remove > duplicate entries between the two lists?