Lease Insert Conditional Fields For Free

Advanced mail merge sends customized messages to large numbers of people, with formulas and conditional statements to make the contents look exactly how you want.

Add individual merge fieldsClick or tap where you want the merge field.Choose the down-arrow under Insert Merge Field, and select a field.If you don't see your field name in the list, choose Insert Merge Field.Choose Database Fields to see the list of fields that are in your data source.Choose Insert.

The curly brackets represent field braces, which you must insert by pressing Ctrl+F9 (you can't type them).Press CTRL+F9.Type IF.Press CTRL+F9.Type "MERGEFIELD" and the name of the field.Go outside the inner brackets.Type the operator and the comparative.Then the true and false options quoted.

To add a conditional field in MS Word, ensure that your text cursor is located in your document where you want the conditional text to display, then click on the "Insert" tab then click on the "Quick Parts" icon in the "Text" group (Newer versions of Word will not have the Quick Parts icon, but they will have the Field

When entering the IF function, format the true text and false text as you want them to appear. This could be a different colour, bold, underlined, larger. Whatever you need.

Click Insert Word Field and select If...then...else. A screen appears allowing you to select the field you want to evaluate. Select the field name from the Field name list that corresponds to the data field on your Control Report that will be used to create the conditional statements.

Place your cursor where you want the conditional text to go. Go to Mailings > Rules > If...Then... Else. In the Field name list choose the field from your data source that will determine the conditional text.