[FMW]

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!

[macropod[_2_]]

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!