• In the Word merge wizard, perform a simple merge
       
    • When editing the merge document, Insert Word Field If...Then...Else using the following fields:

        Field Name: Total_Due

        Comparison: Greater than

        Compare to: insert installment amount

        Insert the text: You are past due

        Otherwise insert this text: You are on time

      Insert Word Field If

      • Click OK, and in the main document screen, add Installment Amount field by Insert Raiser's Edge field, so that the final result reads as follows:
         
          {IF {MERGEFIELD Total Due}>{MERGEFIELD Installment Amount} "You are past due" "You are on time"}
         
        • You can then create each letter within the sets of parentheses

          note: be sure that "insert installment amount" is completely replaced, including the parentheses