Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default combining two recipient lists

One certain way to do it is to use each recipient list as the data source
for a Directory type mail merge. In the mail merge main document, insert a
one row table with as many columns as you have fields in your data source
and after attaching one of the recipient lists to that main document as the
data source, insert the merge fields into the cells of the table. Then,
when you execute that merge to a new document, that document will contain a
table with a row of data for each record in the data source.

Repeat that process for the other recipient list so that you then have two
documents with each one containing a table that is populated with the
records from the recipient lists. Then copy the table from one document
and paste it into the other document at the bottom of the table. Then
remove the empty paragraph(s) between the two tables so that they join
together. Finally, insert a new row at the top of the table and into the
cells of that row, insert names to be used as the merge field names. Then,
you can save that document and use it as the data source for the mail merge
that you originally wished to create.

Depending upon type of the recipient lists, there may be other ways of doing
it, but the above method will work for any type of data source.

--
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

"Dr. Dave" wrote in message
...
I am using Word 2007 with Vista. I have two different recipient lists for
mail merge with different names. How do I combine them into one list?



  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dr. Dave Dr. Dave is offline
external usenet poster
 
Posts: 17
Default combining two recipient lists

I am using Word 2007 with Vista. I have two different recipient lists for
mail merge with different names. How do I combine them into one list?

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dr. Dave Dr. Dave is offline
external usenet poster
 
Posts: 17
Default combining two recipient lists

Thanks!

"Doug Robbins - Word MVP" wrote in message
...
One certain way to do it is to use each recipient list as the data source
for a Directory type mail merge. In the mail merge main document, insert
a one row table with as many columns as you have fields in your data
source and after attaching one of the recipient lists to that main
document as the data source, insert the merge fields into the cells of the
table. Then, when you execute that merge to a new document, that document
will contain a table with a row of data for each record in the data
source.

Repeat that process for the other recipient list so that you then have two
documents with each one containing a table that is populated with the
records from the recipient lists. Then copy the table from one document
and paste it into the other document at the bottom of the table. Then
remove the empty paragraph(s) between the two tables so that they join
together. Finally, insert a new row at the top of the table and into the
cells of that row, insert names to be used as the merge field names.
Then, you can save that document and use it as the data source for the
mail merge that you originally wished to create.

Depending upon type of the recipient lists, there may be other ways of
doing it, but the above method will work for any type of data source.

--
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

"Dr. Dave" wrote in message
...
I am using Word 2007 with Vista. I have two different recipient lists for
mail merge with different names. How do I combine them into one list?




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default combining two recipient lists

A directory (or catalog) merge is a merge document type in which each record
immediately follows the next without starting a new page - as in a letter
merge.
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm neither of which is
solely about labels and which explain how to change the document type and
how to merge to a new document.

--

Graham Mayor - Word MVP

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



Dr. Dave wrote:
Actually, it seems I said thanks prematurely. I tried doing what you
said but I got stuck at not knowing what a "directory type mail
merge" is, or how to "execute that merge to a new document". I tried
"print to file" but that didn't yield anything useful. Could you
clarify? "Dr. Dave" wrote in message
...
Thanks!

"Doug Robbins - Word MVP" wrote in message
...
One certain way to do it is to use each recipient list as the data
source for a Directory type mail merge. In the mail merge main
document, insert a one row table with as many columns as you have
fields in your data source and after attaching one of the recipient
lists to that main document as the data source, insert the merge
fields into the cells of the table. Then, when you execute that
merge to a new document, that document will contain a table with a
row of data for each record in the data source.

Repeat that process for the other recipient list so that you then
have two documents with each one containing a table that is
populated with the records from the recipient lists. Then copy
the table from one document and paste it into the other document at
the bottom of the table. Then remove the empty paragraph(s)
between the two tables so that they join together. Finally, insert
a new row at the top of the table and into the cells of that row,
insert names to be used as the merge field names. Then, you can
save that document and use it as the data source for the mail merge
that you originally wished to create. Depending upon type of the
recipient lists, there may be other ways
of doing it, but the above method will work for any type of data
source. --
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

"Dr. Dave" wrote in message
...
I am using Word 2007 with Vista. I have two different recipient
lists for mail merge with different names. How do I combine them
into one list?



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dr. Dave Dr. Dave is offline
external usenet poster
 
Posts: 17
Default combining two recipient lists

Actually, it seems I said thanks prematurely. I tried doing what you said
but I got stuck at not knowing what a "directory type mail merge" is, or how
to "execute that merge to a new document". I tried "print to file" but that
didn't yield anything useful. Could you clarify?
"Dr. Dave" wrote in message
...
Thanks!

"Doug Robbins - Word MVP" wrote in message
...
One certain way to do it is to use each recipient list as the data source
for a Directory type mail merge. In the mail merge main document, insert
a one row table with as many columns as you have fields in your data
source and after attaching one of the recipient lists to that main
document as the data source, insert the merge fields into the cells of
the table. Then, when you execute that merge to a new document, that
document will contain a table with a row of data for each record in the
data source.

Repeat that process for the other recipient list so that you then have
two documents with each one containing a table that is populated with the
records from the recipient lists. Then copy the table from one document
and paste it into the other document at the bottom of the table. Then
remove the empty paragraph(s) between the two tables so that they join
together. Finally, insert a new row at the top of the table and into the
cells of that row, insert names to be used as the merge field names.
Then, you can save that document and use it as the data source for the
mail merge that you originally wished to create.

Depending upon type of the recipient lists, there may be other ways of
doing it, but the above method will work for any type of data source.

--
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

"Dr. Dave" wrote in message
...
I am using Word 2007 with Vista. I have two different recipient lists
for mail merge with different names. How do I combine them into one
list?







  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dr. Dave Dr. Dave is offline
external usenet poster
 
Posts: 17
Default combining two recipient lists

thanks for the help.
"Graham Mayor" wrote in message
...
A directory (or catalog) merge is a merge document type in which each
record immediately follows the next without starting a new page - as in a
letter merge.
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm neither of which is
solely about labels and which explain how to change the document type and
how to merge to a new document.

--

Graham Mayor - Word MVP

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



Dr. Dave wrote:
Actually, it seems I said thanks prematurely. I tried doing what you
said but I got stuck at not knowing what a "directory type mail
merge" is, or how to "execute that merge to a new document". I tried
"print to file" but that didn't yield anything useful. Could you
clarify? "Dr. Dave" wrote in message
...
Thanks!

"Doug Robbins - Word MVP" wrote in message
...
One certain way to do it is to use each recipient list as the data
source for a Directory type mail merge. In the mail merge main
document, insert a one row table with as many columns as you have
fields in your data source and after attaching one of the recipient
lists to that main document as the data source, insert the merge
fields into the cells of the table. Then, when you execute that
merge to a new document, that document will contain a table with a
row of data for each record in the data source.

Repeat that process for the other recipient list so that you then
have two documents with each one containing a table that is
populated with the records from the recipient lists. Then copy
the table from one document and paste it into the other document at
the bottom of the table. Then remove the empty paragraph(s)
between the two tables so that they join together. Finally, insert
a new row at the top of the table and into the cells of that row,
insert names to be used as the merge field names. Then, you can
save that document and use it as the data source for the mail merge
that you originally wished to create. Depending upon type of the
recipient lists, there may be other ways
of doing it, but the above method will work for any type of data
source. --
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

"Dr. Dave" wrote in message
...
I am using Word 2007 with Vista. I have two different recipient
lists for mail merge with different names. How do I combine them
into one list?




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
Multilevel lists become simple numbered lists in Word 2007 Dwolfe Page Layout 3 July 16th 08 10:37 AM
combining font lists ceracat Microsoft Word Help 3 December 22nd 07 11:20 PM
combining two fonts yamci Microsoft Word Help 1 October 30th 07 11:35 AM
Combining a / and a 0 Bav Microsoft Word Help 9 September 23rd 07 12:00 AM
combining lists in mail merge visiondoc Mailmerge 2 September 27th 06 06:50 AM


All times are GMT +1. The time now is 07:02 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"