Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Eye Eye is offline
external usenet poster
 
Posts: 1
Default how do I combine two mailing lists and remove duplicates

how do I combine two mailing lists (from Excel) into Word and remove
duplicate entries between the two lists?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default how do I combine two mailing lists and remove duplicates

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...mail_merge.htm
--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


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



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
Combine slightly dissimilar lists into one without duplication Fouachaud Microsoft Word Help 1 December 22nd 06 12:04 AM
Mailing Lists Michael Koerner Mailmerge 3 December 7th 06 05:06 PM
mail merge, combine address lists LYNN80123 Mailmerge 1 October 19th 06 03:38 PM
How do you combine several mail merge lists into one? lisabeth Mailmerge 1 October 11th 06 03:51 PM
Combine several lists spevack Mailmerge 1 July 21st 06 04:36 AM


All times are GMT +1. The time now is 03:41 AM.

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"