Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2018, 07:43 AM
gmayor's Avatar
gmayor gmayor is offline IF Statement in Word Windows 10 IF Statement in Word Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can insert a series of conditional fields (noting the reference to MERGEFIELD
{IF { MERGEFIELD "Request_Staff_Person" } = "Minnie Mouse" "Mickey Mouse"}{IF { MERGEFIELD "Request_Staff_Person" } = "Donald Duck" "Another Mouse"}etc
Use CTRL+F9 for each bracket pair { } and no spaces between the items; but frankly it might be better if you modified the data source to include the appropriate bosses.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 02-23-2018, 08:22 AM
nbuckwheat nbuckwheat is offline IF Statement in Word Windows 8 IF Statement in Word Office 2010 64bit
Novice
IF Statement in Word
 
Join Date: Feb 2018
Posts: 9
nbuckwheat is on a distinguished road
Default

Thank you so much, I'll give this a try. Unfortunately, the managers' names are not in our database, and I don't believe there are plans to add them, the best I could do was to modify the source by adding the available field for the secretaries.

One additional question, is there a limit to how many if statements I can run together?
Reply With Quote
  #3  
Old 02-23-2018, 09:46 AM
nbuckwheat nbuckwheat is offline IF Statement in Word Windows 8 IF Statement in Word Office 2010 64bit
Novice
IF Statement in Word
 
Join Date: Feb 2018
Posts: 9
nbuckwheat is on a distinguished road
Default

This did no work for me.
Reply With Quote
  #4  
Old 02-23-2018, 11:10 AM
Charles Kenyon Charles Kenyon is offline IF Statement in Word Windows 10 IF Statement in Word Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,536
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by nbuckwheat View Post
***

One additional question, is there a limit to how many if statements I can run together?
There is no limit to the number of IF Fields you can have, so long as they are independent (not nested, one inside the other).
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statement in Word IF statement in Word VBA BristolJGM Word VBA 2 09-16-2017 06:02 AM
and if statement in word mailmerge sbye Mail Merge 17 08-25-2017 09:59 PM
VBA Word - Find & Apply Styles to Specific Words - Using Case Statement jc491 Word VBA 17 12-26-2015 12:25 PM
IF Statement in Word Microsoft Word IF statement issues micro44 Word 4 10-23-2014 12:10 PM
Help with IF statement in word 2010 Mad Word 2 04-06-2013 06:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft