Consolidate Conditional Field Resolution For Free

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.

Now, Word does not have a Conditional Formatting button like in Excel, but you can write an IF function in the field and format the true and false responses. This will create the perfect Conditional Formatting behaviour.

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.

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

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.

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.

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.

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.