Article ID: 211363 - Last Review: July 27, 2006 - Revision: 2.2 How to specify multiple conditions with a nested IF field in WordThis article was previously published under Q211363 For a Microsoft Word 98 Macintosh Edition version of
this article, see
189026
(http://support.microsoft.com/kb/189026/
)
. For a Microsoft Word 97 version of this article, see
177287
(http://support.microsoft.com/kb/177287/
)
. On This PageSUMMARY 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
(http://support.microsoft.com/kb/214827/EN-US/
)
WD2000: How to Use Nested IF Fields in a Mail Merge Document
212028
(http://support.microsoft.com/kb/212028/EN-US/
)
WD2000: How to Use Conditional Field to Specify Number of Digits
212178
(http://support.microsoft.com/kb/212178/EN-US/
)
WD2000: Cannot Merge a Barcode Field Based on a Condition
220250
(http://support.microsoft.com/kb/220250/EN-US/
)
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 MetTo 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:
To Test Whether One Condition Is MetTo 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:
| Article Translations
|
Back to the top
