Hi, I'm trying to create a mailmerge using an excel spreadsheet. Within the
spreadsheet I have primary and secondary records. They are sorted by a code
and an indicator of Primary vs. Secondary. (All records for a code are
grouped together with Primary listed first.) The secondary record can be as
little as no records or as many as 10 records. What I'd like to do is merge
the Primary record into a form in Word, then merge by the Secondary record(s)
in the same form. After the code changes, I want it to move on to the next
form and begin again. Any ideas?

I.e.,
Record 1 - Primary #1
Record 2 - Secondary #1
Record 3 - Secondary #2

Next Page

Record #4 - Primary #2
Record #5 - Secondary #1

Next Page

Record #6 - Primary #3

Next Page

Record #7 - Primary #4
Record #8 - Secondary #1
Record #9 - Secondary #2
Record #10 - Secondary #3
Record #11 - Secondary #4

Next Page

(Etc.)

--
Peely