You are currently offline, waiting for your internet to reconnect

WD2000: How to Merge Conditional Number of Records to Same Page

This article was previously published under Q212375
SUMMARY
In Microsoft Word, you can merge a conditional number of records tothe same page.
MORE INFORMATION
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"<AngularNoBind>}}</AngularNoBind>{nextif {mergefield check}=""}{if   {duplicate}="on" "P   t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"   "off" "on"<AngularNoBind>}}</AngularNoBind>{nextif {mergefield check}=""}{if {duplicate}="on" "P   t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"   "off" "on"<AngularNoBind>}}</AngularNoBind>{nextif {mergefield check}=""}{if {duplicate}="on" "P   t{MERGEFIELD Project}"}{set duplicate {if {MERGEFIELD Check}="1"   "off" "on"<AngularNoBind>}}</AngularNoBind>{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				
catalog index list table print merge mail group report detail
Properties

Article ID: 212375 - Last Review: 12/28/2000 08:28:00 - Revision: 1.0

  • Microsoft Word 2000 Standard Edition
  • kbinfo kbmerge kbfield KB212375
Feedback