Consolidate Conditional Field Record For Free

Mail merge: Match Fields. To make sure that Word can find a column in your data file that corresponds to every address or greeting element, you may need to match the mail merge fields in Word to the columns in your data file.

To add a formula, start by typing the equal sign. Go to the MAILINGS tab and insert the Mileage merge field. You could also press Ctrl +F9, and type it manually. After the merge field, type +6000, and finally, add the switch to format the number with a comma.

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.

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 conditional formatting On the form template, select the control that you want to add conditional formatting to, and then click Conditional Formatting on the Format menu. In the Conditional Formatting dialog box, click Add. In the If this condition is true boxes, enter the condition.

Add individual merge fields Click 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.

Add individual merge fields Click 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.

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.

Add individual merge fields Click 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.

How to get mail merge to match fields In the Insert Address Block or Insert Greeting Line dialog box, click the Match Fields button.In the Match Fields dialog box that pops up, you will see the list of fields required for a given block.