How can I use multiple IF, THEN, ELSE in Word Mail Merge?

[gregw]

Using Mail Merge in a non-profit for donor letters, I want to print different
sentences for multiple donation categories. $1-50, $51-$100, $101-$500,
$501-$1000, over $1000 as an example. Is there a way to do this using
multiple IF, THEN, ELSE conditions?

Greg

 

[Doug Robbins]

You can do the following:

{ IF { MERGEFIELD "Donation" } < 51 "Use this sentence for less than 51" {
IF { MERGEFIELD "Donation" } < 101 "Use this sentence for 51 to 100" "Use
this sentence for more than 100 "} }

You must use Ctrl+F9 for each pair of field delimiters { }, Alt+F9 to toggle
them off and F9 to update the fields. Using the same principle as in the
<51 construction, you can expand the field to include more values.
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP