Create Nested IF Fields for Multiple Yes or No Answers in Word Mail Merge
Question details
Create a Word mail merge that displays descriptions for three yes-or-no fields and shows Not applicable when all three answers are No.

- Product
- Microsoft Word Mail Merge
- Device & OS
- not provided
- Scenario
- A mail merge document uses PVG, SSSC, and GTCS responses to determine which descriptions appear for each recipient.
- Observed behavior
- The merged document should show every description associated with a Yes response, or Not applicable if all three responses are No.
Connect the Word document to a mail merge recipient list using Mailings > Select Recipients. Check that the list contains columns named PVG, SSSC, and GTCS with Yes or No values.
Use separate IF fields and a nested IF for the all-No condition
Use this approach to display every applicable description and a fallback only when all three responses are No.
The examples below show Word field codes. Each pair of field braces must be inserted as a real field; typing braces on the keyboard will not work. Keep the spaces inside the quoted descriptions so multiple results do not run together.
In the document, place the cursor where the descriptions should appear. Press Ctrl+F9 on Windows or Command+F9 on Mac to insert field braces. Inside them, create the following field, inserting the nested merge field through Mailings > Insert Merge Field: { IF "{ MERGEFIELD PVG }" = "Yes" "Protecting Vulnerable Groups scheme " "" }.
Immediately after the first field, insert two more IF fields using field braces and Mailings > Insert Merge Field: { IF "{ MERGEFIELD SSSC }" = "Yes" "Scottish Social Service Council " "" } and { IF "{ MERGEFIELD GTCS }" = "Yes" "General Teaching Council Scotland " "" }. Keep all three fields in the same paragraph if you want the descriptions on one line.
After the three description fields, insert this nested field, using field braces for every IF and inserting each merge field through Mailings > Insert Merge Field: { IF "{ MERGEFIELD PVG }" = "No" "{ IF "{ MERGEFIELD SSSC }" = "No" "{ IF "{ MERGEFIELD GTCS }" = "No" "Not applicable" "" }" "" }" "" }. It displays the fallback only when all three values are No.
Select Mailings > Preview Results and use the recipient arrows to check records with multiple Yes answers and with all No answers. If field codes are visible, toggle them off and preview again.

Work with mail merge documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office documents. Its format compatibility helps you move existing files into WPS; verify complex Word field behavior before relying on it for a merge.

Frequently Asked Questions
Can the merge show more than one description?
Yes. The three separate IF fields each test their own merge field, so every field with a Yes response can contribute its description.
Why does Not applicable not appear for a record?
The nested fallback requires PVG, SSSC, and GTCS all to contain No. Check the recipient's source cells for blanks, extra spaces, or different values, then use Mailings > Preview Results again.
Can I type the braces around Word field codes?
No. Insert each pair of field braces with Ctrl+F9 on Windows or Command+F9 on Mac. Use Mailings > Insert Merge Field to insert the merge fields inside the IF fields.
How can I check the output before completing the merge?
Choose Mailings > Preview Results and move through recipients with the arrows. Test a record with multiple Yes values and another with all No values.




