Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I use multiple IF, THEN, ELSE in Word Mail Merge?
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 |
#2
|
|||
|
|||
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 "gregw" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
WP Delay Code - Word Equiv | Microsoft Word Help | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help | |||
Word Attachments open multiple copies of Word | Microsoft Word Help |