Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2008

Tip: Looking for answers? Try searching our database.

Mail merge with several lists

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jennifer - 04 Apr 2008 18:18 GMT
I have completed a mailing using mail merge.  Now we have decided on another
group of people to sent to... Is there an easy way for me to make sure people
in group 2 are not also in group 1?
Doug Robbins - Word MVP - 04 Apr 2008 22:49 GMT
Sorting the lists in the same way would simplify a manual check.

I would however get them both into tables in Excel and then use a Find
Duplicates query there to identify the duplicates.

You could also make use of the example 4 in the article "Finding and
replacing characters using wildcards" at:

http://www.word.mvps.org/FAQs/General/UsingWildcards.htm

Or you could create a macro that iterated through the records in one list
and compare each one with the records in the other list.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have completed a mailing using mail merge.  Now we have decided on
>another
> group of people to sent to... Is there an easy way for me to make sure
> people
> in group 2 are not also in group 1?
Jennifer - 07 Apr 2008 15:03 GMT
I'm thinking that those suggestions are a little beyond me but I will give it
a try..lol

> Sorting the lists in the same way would simplify a manual check.
>
[quoted text clipped - 14 lines]
> > people
> > in group 2 are not also in group 1?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.