I am building a mail merge document that will print instructor assignments for several instructor teams and within each team they are responsible several groups of students. On each change in TEAM number and on each change in RUNGROUP name I would like to skip to a new printed page.
As an example, Team #1 has twenty students. Five in each RunGroup – Green, Blue, Yellow, White. Each printed page in the attached document has a place for three student assignments. Therefore, the first three greens will be on the first page. The last two greens on the second page. Leave the third section on page two blank and skip to a new page to begin the Blue group. Same process when the data changes from Team #1 to Team #2.
The data is in an Excel 2007 file.