Can you do a cc in a mail merge

Yes, you can do a conditional calculation (CC) in a mail merge. In Microsoft Word, you can use the IF function to perform a CC in a mail merge.

Here's an example:

Suppose you have a mail merge document that includes a field for the customer's age, and you want to display a message that says "Senior" if the customer is 65 or older, and "Not a Senior" otherwise.

You can use the following syntax:

IF({Age} >= 65, "Senior", "Not a Senior")

This will evaluate the value in the Age field and display "Senior" if it's 65 or older, and "Not a Senior" otherwise.

You can also use more complex CCs by combining multiple conditions using logical operators (AND, OR, NOT). For example:

IF({Age} >= 65 AND {Income} > 50000, "High-Income Senior", "Not a Senior")

This will evaluate the value in the Age field and the Income field, and display "High-Income Senior" if the customer is 65 or older and has an income of $50,000 or more, and "Not a Senior" otherwise.

To use a CC in a mail merge, follow these steps:

  1. Open your mail merge document in Microsoft Word.
  2. Insert a field where you want the CC to appear.
  3. Right-click on the field and select "Insert Merge Field".
  4. In the "Insert Merge Field" dialog box, select the field that contains the value you want to use in the CC.
  5. In the "Merge Field" dialog box, click on the "Formula" button.
  6. In the "Formula" dialog box, enter the CC syntax using the IF function.
  7. Click "OK" to close the "Formula" dialog box.
  8. Click "OK" to close the "Insert Merge Field" dialog box.

The CC will be inserted into the document, and will be evaluated based on the values in the mail merge fields.