combining lists in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

visiondoc - 26 Sep 2006 22:39 GMT

I have two recipient lists created in mail merge by two different staff
members They are in the shared documents folder How do I merge or combine
these two lists into one so that I can use it for a mailing?

Reply to this Message

Peter Jamieson - 27 Sep 2006 00:58 GMT

Are these "office address lists" created in Word 2002/2003 mail merge?

Do you have Access or Excel?

If you have Access or Excel, can you please try to copy the two .mdb files
containing the data, open them in "datasheet" mode, and paste the result
into a new database table or spreadseet)

Otherwise, if that does not help, can you say whether or not you have
a. Access
b. Excel

Peter Jamieson

> I have two recipient lists created in mail merge by two different staff
> members They are in the shared documents folder How do I merge or
> combine
> these two lists into one so that I can use it for a mailing?

Reply to this Message

Graham Mayor - 27 Sep 2006 06:50 GMT

Another way is to create a Directory merge into a single row table of all
the matching fields from the two data files.
Merge each data file using the same source document to a new document. Copy
and paste one of the new documents into the other. Sort the table on
whichever column seems appropriate. Add a title row to the table and use the
saved documnent with this table as a data source.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> I have two recipient lists created in mail merge by two different
> staff members They are in the shared documents folder How do I
> merge or combine these two lists into one so that I can use it for a
> mailing?

Reply to this Message

Rate this thread: