How to specify multiple conditions with a nested IF field in Word

Article translations Article translations
Article ID: 211363 - View products that this article applies to.
This article was previously published under Q211363
For a Microsoft Word 98 Macintosh Edition version of this article, see 189026.
For a Microsoft Word 97 version of this article, see 177287.
Expand all | Collapse all

On This Page

SUMMARY

In a mail merge main document, you can use an IF (IF...THEN...ELSE) conditional statement to check whether one condition or multiple conditions are met.

This article provides a method of nesting COMPARE statements in an IF field to test whether the conditions you want are met.

For additional information about evaluating MERGEFIELDS without using the COMPARE field, click the article numbers below to view the articles in the Microsoft Knowledge Base:
214827 WD2000: How to Use Nested IF Fields in a Mail Merge Document
212028 WD2000: How to Use Conditional Field to Specify Number of Digits
212178 WD2000: Cannot Merge a Barcode Field Based on a Condition
220250 WD2000: Err Msg: "Fields Are Nested Too Deeply" in Mail Merge

MORE INFORMATION

You can specify multiple conditions by nesting a COMPARE field inside an IF field.

NOTE: To type field braces ( { } ) in a Word document, press CTRL+F9. To turn field codes on or off, press ALT+F9.

To Test Whether Multiple Conditions Are Met

To test whether multiple fields meet certain conditions, you can use an AND conditional statement in your mail merge main document similar to the following:

{ IF { = AND ( { COMPARE { MERGEFIELD Field_1 } = "Value"}, { COMPARE { MERGEFIELD Field_2 } = "Value" } ) } = 1 "True Instructions" "False Instructions" }
The result of these nested COMPARE statements is the "True Instructions" when both Field_1 and Field_2 are equal to "Value"; otherwise, the "False Instructions" is given as the result.

NOTES:
  • When all of the conditions of the AND statement are met, the value returned by the statement is equal to 1 (this results in the True Instructions being returned).
  • When all of the conditions of the AND statement are not met, the value returned by the statement is equal to 0 (this results in the False Instructions being returned).

To Test Whether One Condition Is Met

To test whether one of the fields meets a particular condition, you can use an OR conditional statement in your mail merge main document similar to the following:
{ IF { = OR ( { COMPARE { MERGEFIELD Field_1 } <= "Value" }, { COMPARE { MERGEFIELD Field_2 } >= "Value" } ) } = 1 "True Instructions" "False Instructions" }
The result of these nested COMPARE statements is the "True Instructions" when either Field_1 or Field_2 is equal to "Value"; otherwise, the "False Instructions" is given as the result.

NOTES:
  • When any of the conditions of the OR statement is met, the value returned by the statement is equal to 1 (this results in the True Instructions being returned).
  • When all of the conditions of the OR statement are not met, the value returned by the statement is equal to 0 (this results in the False Instructions being returned).

Properties

Article ID: 211363 - Last Review: July 27, 2006 - Revision: 2.2
APPLIES TO
  • Microsoft Word 2002 Standard Edition
  • Microsoft Word 2000 Standard Edition
Keywords: 
kbhowto kbprogramming kbmerge kbfield KB211363

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com