WD2000: How to Specify Multiple Conditions with a Nested IF

ID: Q211363

The information in this article applies to:

Microsoft Word 2000

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:

Q214827 WD2000: How to Use Nested IF Fields in a Mail Merge Document

Q212028 WD2000: How to Use Conditional Field to Specify Number of Digits

Q212178 WD2000: Cannot Merge a Barcode Field Based on a Condition

Q220250 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

Keywords : kbfield kbmerge wd2000
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto