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?
This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.
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:
- In Microsoft Word, open the mail merge document and place your cursor where you wish the yes/no data to appear.
- From the , in the "Insert Word Field" drop-down menu, select .
- 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. - From the "Comparison:" drop-down menu, select .
- In the "Compare to:" text box, enter
True
. - In the "Insert this text:" text box, enter
yes
. - In the "Otherwise insert this text:" text box, enter
no
. - Click .
This is document ahww in the Knowledge Base.
Last modified on 2018-01-18 12:31:37.