If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
New Page when a particular field changes value
I am trying to mail merge from an excel file which contains several records
per person, each record unique in some respect. I want to print selected field so that each person's name appears at the top or the page, and their selected data apears in a table on that page, and a new page is started when the next record relates to a different person. The number of records per person varies between 6 and 12, and I would like one row in the table for each record. There are about 800 rows in total! |
#2
|
|||
|
|||
New Page when a particular field changes value
Hi FMW,
You can use Word's Catalogue/Directory Mailmerge facility for this (the terminolgy depends on the Word version). To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "FMW" wrote in message ... I am trying to mail merge from an excel file which contains several records per person, each record unique in some respect. I want to print selected field so that each person's name appears at the top or the page, and their selected data apears in a table on that page, and a new page is started when the next record relates to a different person. The number of records per person varies between 6 and 12, and I would like one row in the table for each record. There are about 800 rows in total! |
Thread Tools | |
Display Modes | |
|
|