1 réponse
The apparently complicated problem becomes simple with the use of the Word command Insert a merge field (mail merge).
In your Excel database, let's imagine that a column (which will be a merge field in Word) contains a binary value (YES or NO, TRUE or FALSE, M or F, etc.). Instead of integrating this field, you need to insert a keyword If ... then ... else by specifying your field name and leaving the text boxes empty.
Once this step is complete, display the field codes with ALT + F9.
Fill in the texts between the quotes by inserting the checkboxes from the Insert special characters menu (Wingdings2 font).
If the field is identified as GENDER, here’s what it should look like:
{ IF { MERGEFIELD GENDER } = "M" "insert the checked special character" "insert the unchecked character" }
By switching back (Alt+F9) and activating the mail merge mode, you will see that the box is checked or unchecked according to the value of your field.
Good luck with the test.
In your Excel database, let's imagine that a column (which will be a merge field in Word) contains a binary value (YES or NO, TRUE or FALSE, M or F, etc.). Instead of integrating this field, you need to insert a keyword If ... then ... else by specifying your field name and leaving the text boxes empty.
Once this step is complete, display the field codes with ALT + F9.
Fill in the texts between the quotes by inserting the checkboxes from the Insert special characters menu (Wingdings2 font).
If the field is identified as GENDER, here’s what it should look like:
{ IF { MERGEFIELD GENDER } = "M" "insert the checked special character" "insert the unchecked character" }
By switching back (Alt+F9) and activating the mail merge mode, you will see that the box is checked or unchecked according to the value of your field.
Good luck with the test.