Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multilevel lists become simple numbered lists in Word 2007 | Page Layout | |||
combining font lists | Microsoft Word Help | |||
combining two fonts | Microsoft Word Help | |||
Combining a / and a 0 | Microsoft Word Help | |||
combining lists in mail merge | Mailmerge |