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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gregw - 21 Feb 2005 23:33 GMT

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

Reply to this Message

Doug Robbins - 22 Feb 2005 00:34 GMT

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.

Signature

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

> Using Mail Merge in a non-profit for donor letters, I want to print
> different
[quoted text clipped - 3 lines]
>
> Greg

Reply to this Message