Combine Conditional Field Affidavit For Free

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.

In the Field name drop-down, select the field name on which to base the conditional statement. In the Comparison drop-down, select the appropriate operator. In the Compare to field, enter the appropriate value. In the Insert this text field, enter the statement to use if the value is true.

Almost any mail merge will work better if you use IF fields, as the frequently used scenarios discussed below attempt to illustrate. At their simplest, they can be used to suppress unwanted spaces and commas in an address, if a field is blank.

A conditional mail merge consists of a series of merge documents and one data file; one or more conditional statements ensure your word processor automatically selects the appropriate merge letter for each row of data in your file.

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.

In the Write and Insert Fields section, select Rules, If...Then... Else......On the Insert Word Field:IF screen: In the Field name drop-down, select the field name on which to base the conditional statement. In the Comparison drop-down, select the appropriate operator. In the Compare to field, enter the appropriate value.

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