View Single Post
 
Old 05-14-2018, 04:52 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 162
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