Reply
 
Thread Tools Display Modes
  #1   Report Post  
gregw
 
Posts: n/a
Default 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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
Mail merge - Word 2003/Access 2000 Russell Farr Mailmerge 7 March 24th 06 12:03 AM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
How to change merge forms from Word Perfect to Microsoft Word dollfindance Microsoft Word Help 2 December 30th 04 03:35 PM
Word Attachments open multiple copies of Word rocketman60 Microsoft Word Help 1 December 11th 04 08:06 AM


All times are GMT +1. The time now is 08:07 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"