#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Try:
{SYMBOL {IF{MERGEFIELD Water \* Upper}= "YES" 254 168} \a \f Wingdings}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank You
|
#4
|
||||
|
||||
That looks like you have Word's field code display toggled 'on'. Try pressing Alt-F9 to toggle it 'off'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Thanks Paul ... where would Ifind that setting to uncheck it?
|
#8
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Ahh ... I see.
I thought the Alt-F9 thing applied only to the mail merge document, not the final merged document. |
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 |
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 |