Consolidate Conditional Field Deed For Free

You can insert one or more mail merge fields that pull the information from your spreadsheet into your document. Go to Mailings > Insert Merge Field. Add the field you want. Repeat steps 1 and 2 as needed. Choose File > Save.

You can use your standard salutation by using the Mr. & Mrs. + last name fields. If you want to go that route, click on the Insert Merge Field option, select the Salutation field and hit the Insert button.

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 with If...Then...Else by Chris Menard YouTube Start of suggested clip End of suggested clip I know I have an Excel spreadsheet pulled up I'm gonna do a mail merge with an if statement. SoMoreI know I have an Excel spreadsheet pulled up I'm gonna do a mail merge with an if statement. So here's the example I came up with we have people that signed up for classes in column G and the next to

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 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.