I have an excel spreadsheet with a column that has a Y or N in it. If the column has a Y in the spreadsheet, I want a checkbox to be checked in my MS word 2007 document. But it doesn't seem that straight forward.



From the Mailings tab in Word, I open the 'Rules' item and select If..then..else. I get a box that wants field name (which shows properly), then it asks for Comparisonm I select Equal To. And in the Compare To field I can put Y but I am not sure how the box actually gets checked on the MS word document. My only choices are to insert some text, not take an action like check a box. Do I need to delete the existing checkbox that was created previously and add a new on?