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!

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" <FMW.DeleteThis@discussions.microsoft.com> wrote in message news:011C8C47-088C-4EB2-997C-22708FF04D3F@microsoft.com...
>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!