Populate Word Merge Check Box from exported txt file data (0 vs. 1)
Posted on 2007-10-18
I'm using an Access form to collect data for a MS Word Mail Merge document. In addition to name and address fields, the Access form collects data for several Check Boxes. I export the Access data to a comma delimited text file that the Word document references. My question is how I get Check Box fields on the Mail Merge document to either populate or not-populate based on the 0 or 1 that is in the exported text file. So, if the txt file for the first record has a 1 in the appropriate field I want a filled in Check-Box on the letter, vs. a blank Check Box.
I've exhausted the obvious options in Word help, and can't believe that there isn't a way to do this. Any help/thoughts/ideas would be greatly appreciated. All else fails, I suppose I can change the Access database to export a literal "X" to the text file. I'd rather have the nice Check Box Form field available in Word though.
Thanks for your time.