I am extracting data for a mailmerge document from an excel database.
One field of my report (a column ... B1 ... from the database) can be
only one of three values ("Current Config.", a user entered value, or
blank)
I have check boxes in my merge document that use a merge formula to
populate.
Checkbox 1 ("Reline" is checked when B1 = "Current Config.", and
Checkbox 2 is unchecked.
Checkbox 2 ("Changeover") is checked when B1 = any user entered value,
and checkbox 1 is unchecked
If B1 = blank, or empty, both checkboxes are empty.
The merge formula I have established for Checkbox 1 is very
straightforward:
|