Document Editing Problems

Create Nested IF Fields for Multiple Yes or No Answers in Word Mail Merge

Amos GikundaAmos Gikunda Nov 13, 2026 869 views

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.

Create Nested IF Fields for Multiple Yes or No Answers in Word Mail Merge
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.
Before you start

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.

Solution 1Recommended

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.

1
Insert the first IF field

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 " "" }.

2
Add the other descriptions

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.

3
Add the all-No fallback

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.

4
Preview several recipients

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.

Use separate IF fields and a nested IF for the all-No condition
Match the source values: The conditions assume the source cells contain Yes or No. Check for blank values, extra spaces, or different labels if a result is missing. On some Mac keyboards, inserting a field may also require the Fn key.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word DOC and DOCX filesWork with documents used for mail mergeFamiliar document-editing interfaceFree and lightweight Office alternative
microsoft office alternative - wps office

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.