Use renewal wording only in renewal letters

Make5 minutes

The problem

One letter goes to two groups that need different sentences.

A Word letter reads Your renewal information is enclosed. A yellow highlighter marks it, and an arrow leads to the words not right for both groups.

Why it happens

One letter goes to two groups that need different sentences. Two copies of the letter are twice the work to keep in step.

Fix it

  1. Check that your list has a column naming the group for each row, like Audience, with Renewal or Enrollment.

  2. In your letter, click where the sentence goes.

  3. On the Mailings tab, click Rules, then If...Then...Else.

  4. Set Field name to Audience, Comparison to Equal to, and Compare to to Renewal.

  5. In Insert this text, type "Your renewal information is enclosed." In Otherwise insert this text, type "Your enrollment information is enclosed." Click OK, then Preview Results.

Renewal rows get the renewal sentence. Enrollment rows get the enrollment sentence.

The IF box picks renewal wording when Audience equals Renewal, and enrollment wording otherwise. The preview then shows Your renewal information is enclosed.

Watch for

Every row that isn't Renewal gets the enrollment sentence, even blanks and typos. Before you merge, check that the column holds only Renewal and Enrollment.

Tested in: Word for Windows and Mac

Microsoft's help: Set the rules for a mail merge · IF field