Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2016, 07:55 AM
Rromberg10 Rromberg10 is offline Microsoft Quick Parts IF function issue Windows 8 Microsoft Quick Parts IF function issue Office 2007
Novice
Microsoft Quick Parts IF function issue
 
Join Date: Mar 2016
Posts: 2
Rromberg10 is on a distinguished road
Default Microsoft Quick Parts IF function issue

I am trying to get the IF function to work in my RTF printout via quickparts. I need to base this IF off of another Mergefield and I cannot figure it out. Here is what I have :

IF { MERGEFIELD RegistrantNumber } = "123" "YAY" "NAY"

I go into the application I am using and enter "123" for the Registrant Number field. When the RTF is generated this is what displays

IF 123 = "123" "YAY" "NAY"



I need it to show YAY if the field is 123 and NAY if it is not.
Reply With Quote
  #2  
Old 03-23-2016, 04:08 PM
macropod's Avatar
macropod macropod is offline Microsoft Quick Parts IF function issue Windows 7 64bit Microsoft Quick Parts IF function issue Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The IF test needs to be enclosed in a pair of field braces, thus:
{ IF { MERGEFIELD RegistrantNumber } = "123" "YAY" "NAY" }
To do that, select your current 'IF' test and press Ctrl-F9 - you can't type the braces.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
if then else, mailmerge, quickparts



Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Quick Parts IF function issue Sharing Quick Parts katrinao Word 3 03-04-2016 07:44 AM
Microsoft Quick Parts IF function issue Quick Parts Fields? brucemc777 Word 2 02-16-2016 12:57 PM
Microsoft Quick Parts IF function issue Quick Parts, Fill-In FFT Word 2 08-12-2014 05:49 AM
Microsoft Quick Parts IF function issue Quick Parts tmneal74 Word 1 11-13-2012 06:04 PM
Microsoft Quick Parts IF function issue Quick parts in doc file alokmay Word 1 06-14-2011 04:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 PM.


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