In Microsoft Word, you can merge a conditional number of records to the same page.
Summary
To merge a conditional number of records to the same page, use a combination of SET, IF, and NEXTIF fields. For example, you can use this method to merge all records with the same name to one page in the merge and create a new page in the merge when a new name is encountered in the data file.
The following example uses a data file with employee names (Employee) and projects they are working on (Projects). The Check field is used in the data file to mark the last record of a particular name.
Sample Data File:
Employee Project Check
Scott Cooper 4578j
Scott Cooper 86785x
Scott Cooper 543p 1
Meng Phua 87x
Meng Phua 89976m 1
Kim Yoshida 7897r
Kim Yoshida 857t
Kim Yoshida 78974x
Kim Yoshida 7868p 1
Set up the main document as follows, with a copy of the conditional statements equal to the maximum number of projects for each employee (four in the above example).
Employee Project
{MERGEFIELD Employee} {MERGEFIELD Project}{set duplicate {if
{MERGEFIELD Check}="1" "off" "on"}}{nextif {mergefield check}=""}{if
{duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"
"off" "on"}}{nextif {mergefield check}=""}{if {duplicate}="on" "P
t{MERGEFIELD Project}"}
Where "P" represents a paragraph mark that pushes the next project to a new line, and "t" represents a tab character that aligns the next project under the previous project.
The resulting merge document appears as follows:
Employee Project
Scott Cooper 4578j
86785x
543p
--- Page Break ---
Meng Phua 87x
89976m
--- Page Break ---
Kim Yoshida 7897r
857t
78974x
7868p
