IF THEN Else Statement for multiple values in Microsoft Word

Corinne Sheppard 2

I'm trying to streamline our receipt process by using IF THEN ELSE statements in the receipt Word document (eliminating need for multiple types of receipts).  I'm trying to include an IF THEN ELSE statement that would essentially say "if the fund description is one of the following phrases, insert "being a member" else "your donation to."  Bascially to just differentiate receipts for memberships from regular donation receipts.  Does anyone have any experience with this? It works well if I just use one fund description but I can't figure out how to specify "one of these specific three funds otherwise do this."  It's really easy to do it in Crystal but I'm stumped in Microsoft Word.



Any help is appreciated!



Corinne

Terri Callis

https://www.youtube.com/watch?v=iE2Jn6yrIvk



Have you watched this? Hope it helps. 

Elaine Tucker

If you have the membership module, here is the i/t/e statement from one of our letters:



IF <Constituent\\Membership\\Current\\Type> = "Joined" "Welcome" "Welcome back"



to imbed a 2nd i/t/e/ statment in the above line,remove "Welcome back" and put your next i/t/e inside the quotes where welcome back was the example shown below has additional imbeded statements



IF <Constituent\\Membership\\Current\\Type> = "Joined" "membership" "IF <Constituent\\Membership\\Current\\Type> = "renew" "membership" "IF <Constituent\\Membership\\Current\\Type> = "rejoined" "membership" "donation" " "



We use i/t/e statements on ALL of our gift letters and it works wonders!  It does take some effort if the letters are updated, but that is much easier to edit ONE letter than the multiple letter codes we used to use

Chas Dreyfus

Terri Callis:

https://www.youtube.com/watch?v=iE2Jn6yrIvk



Have you watched this? Hope it helps. 

That's a very nice instruction on using single conditions. Here's a link to a Microsoft How To for both multiple conditions and for constructing a Boolean OR statement: https://support.microsoft.com/en-us/kb/90393.

Terri Callis

Thank you. I will check that out.