ARCHIVED: When I perform a Microsoft Word mail merge using a Microsoft Access table, how do I stop data in the yes/no field from converting to true/false?

If you wish to perform a mail merge in Microsoft Word using an Access table containing data in a yes/no field, the yes/no data will convert to true/false. To avoid this:

1. In Microsoft Word, open the mail merge document and place your cursor where you wish the yes/no data to appear.
   
   
2. From the Mail Merge Toolbar, in the "Insert Word Field" drop-down menu, select If...Then...Else... .
   
   
3. In the Insert Word Field: IF dialog box, from the "Field name:" drop-down menu, select the field name that is the yes/no field in Access.
   
   
4. From the "Comparison:" drop-down menu, select Equal to.
   
   
5. In the "Compare to:" text box, enter True .
   
   
6. In the "Insert this text:" text box, enter yes .
   
   
7. In the "Otherwise insert this text:" text box, enter no .
   
   
8. Click OK.

Comments/Questions/Corrections