Microsoft KB Archive/211363

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

Article ID: 211363

Article Last Modified on 7/27/2006

-

APPLIES TO


 * Microsoft Word 2002 Standard Edition
 * Microsoft Word 2000 Standard Edition

-



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.



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

Additional query words: mailmerge wd2000 wd2002 wd2k

Keywords: kbhowto kbprogramming kbmerge kbfield KB211363

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.