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.

Try:
{SYMBOL {IF{MERGEFIELD Water \* Upper}= "YES" 254 168} \a \f Wingdings}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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?

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]

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.

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]

Thanks Paul ... where would Ifind that setting to uncheck it?

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]

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