Microsoft Office Forums If data value equals target then display text

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2018, 04:52 PM
JennEx JennEx is offline If data value equals target then display text Windows XP If data value equals target then display text Office 2013
Competent Performer
If data value equals target then display text
 
Join Date: May 2010
Posts: 157
JennEx is on a distinguished road
Default If data value equals target then display text


I only have some familiarity with the intricacies of Microsoft Word's mail merge feature. As such, I find myself struggling to find a solution to concept that has become a hurdle.

Here is a portion of my mail merge document. The two table cells containing the checked box and "Water", and the unchecked box and "Hydro" are simply text right now. They have no associated mail merge fields associated to it.



My data source is an Excel document. It has one column labelled water, and another labelled hydro. The values the follow for each record in the dataset can either be empty, or yes.

What I would like to do is place the appropriate checkbox (checked or unchecked) for each of Water and Hydro based on the value in that record's Water and Hydro column respectively.

If the value in either the Water or Hydro is "YES", I would like the checked checkbox to be displayed. If the record value in the respective column is blank, the checkbox shown will be unchecked.

BTW, the checkboxes are simply symbols from the WingDings font.
Reply With Quote
  #2  
Old 05-14-2018, 09:49 PM
macropod's Avatar
macropod macropod is online now If data value equals target then display text Windows 7 64bit If data value equals target then display text Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Try:
{SYMBOL {IF{MERGEFIELD Water \* Upper}= "YES" 254 168} \a \f Wingdings}
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-17-2018, 05:00 PM
JennEx JennEx is offline If data value equals target then display text Windows XP If data value equals target then display text Office 2013
Competent Performer
If data value equals target then display text
 
Join Date: May 2010
Posts: 157
JennEx is on a distinguished road
Default Thank You

I think I must be manually entering this in my field, as I'm getting the wrong results ...
This is the result in my merged document:



Is there a way I can copy what you have and paste it in my document?
Reply With Quote
  #4  
Old 05-17-2018, 06:12 PM
macropod's Avatar
macropod macropod is online now If data value equals target then display text Windows 7 64bit If data value equals target then display text Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

That looks like you have Word's field code display toggled 'on'. Try pressing Alt-F9 to toggle it 'off'.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 05-21-2018, 04:33 PM
JennEx JennEx is offline If data value equals target then display text Windows XP If data value equals target then display text Office 2013
Competent Performer
If data value equals target then display text
 
Join Date: May 2010
Posts: 157
JennEx is on a distinguished road
Default

Hi Paul, thanks for stepping up with assistance.
This issue, as well as the one posted here
https://www.msofficeforums.com/mail-...tml#post128578
appears to be unique to my home computer. These problems, as well as other odd mail merge deficiencies I am unable to replicate on my office computer. Everything works perfect on my work computer.


This is another merge field (click thumbnail below) that refuses to populate properly on my home computer but works flawlessly on my work computer.


Reply With Quote
  #6  
Old 05-21-2018, 04:42 PM
macropod's Avatar
macropod macropod is online now If data value equals target then display text Windows 7 64bit If data value equals target then display text Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

All that means regarding the field code display, is that one PC has the 'display field codes instead of their values' option checked and the other doesn't.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 05-21-2018, 06:44 PM
JennEx JennEx is offline If data value equals target then display text Windows XP If data value equals target then display text Office 2013
Competent Performer
If data value equals target then display text
 
Join Date: May 2010
Posts: 157
JennEx is on a distinguished road
Default

Thanks Paul ... where would Ifind that setting to uncheck it?
Reply With Quote
  #8  
Old 05-21-2018, 09:24 PM
macropod's Avatar
macropod macropod is online now If data value equals target then display text Windows 7 64bit If data value equals target then display text Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Under File|Options|Advanced>Show document content. As I said before, though, you can toggle this setting on/off via Alt-F9.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 05-23-2018, 02:41 PM
JennEx JennEx is offline If data value equals target then display text Windows XP If data value equals target then display text Office 2013
Competent Performer
If data value equals target then display text
 
Join Date: May 2010
Posts: 157
JennEx is on a distinguished road
Default

Ahh ... I see.
I thought the Alt-F9 thing applied only to the mail merge document, not the final merged document.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How keep target text format when copying from other source? Kokopelli Excel 8 10-11-2016 11:34 PM
Too many email addresses equals no send seaboyd Outlook 0 02-23-2015 11:00 AM
If data value equals target then display text Adding up cells if value equals Kh1978 Excel 6 07-15-2014 12:48 PM
Insert space before and after target text Marrick13 Word VBA 6 06-20-2014 07:46 AM
Match two sets of data and display specific data lolly150 Excel 1 05-14-2012 10:33 PM


All times are GMT -7. The time now is 03:35 PM.


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