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,962
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

Thread Tools
Display Modes


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 07:21 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