How to Mail Merge With Multiple Recipients per Letter

When you run a standard mail merge in Word, each recipient gets their own letter. But sometimes you need one letter addressed to multiple people at the same company or household. For example, you might want to send a single notice to both John Smith and Jane Smith at the same address. The default mail merge cannot do this because it treats each row in your data source as one recipient.

The solution is to group your data by a shared key such as a household ID or company name. You then use the catalog or directory merge type to create a list per group. After merging, you manually insert page breaks or section breaks to separate each group. This article explains how to prepare your data, set up the merge, and format the output so that one letter contains multiple names.

You will learn the exact steps to build a data source with a grouping field, run a catalog merge, and add conditional formatting that keeps all recipients for the same group on one page.

Why the Default Mail Merge Cannot Handle Multiple Recipients per Letter

The standard mail merge in Word is designed for a one-to-one relationship. Each row in your Excel table or Access query produces one letter, one email, or one envelope. When you need one letter that lists two or more people at the same address, the default behavior creates duplicate letters instead of a combined list.

The technical limitation is that Word does not natively support grouping during the merge. It processes rows sequentially without comparing values between rows. To work around this, you must use the Directory (catalog) merge type and then insert a field that checks whether the current row belongs to the same group as the previous row.

This method requires a data source that contains a grouping column. Common examples are a Household ID, a Company Name, or a Customer Account Number. Every row that should appear in the same letter must have the same value in that column.

Prerequisites Before You Start

You need a data source such as an Excel worksheet, an Access table, or a CSV file. The data source must have at least these columns:

• Group ID: A value that all members of the same letter share. For example, a Household ID of 1001 for both John and Jane Smith.
• Recipient fields: First Name, Last Name, Address, City, State, ZIP, and any other fields you want to appear in the letter.

Sort the data source by the Group ID column so that all rows for the same group appear consecutively. If you use Excel, select the entire table, go to Data > Sort, and sort by the Group ID column in ascending order.

Steps to Create a Mail Merge With Multiple Recipients per Letter

Follow these steps in Word for Windows or Word for Mac. The screenshots and menu names refer to Word for Microsoft 365 on Windows 11. The steps are nearly identical on Mac with minor menu differences.

1. Prepare and sort your data source
   Open your data source in Excel. Add a column named GroupID or HouseholdID. Fill in the same number for every row that belongs to one letter. Sort the entire table by this column. Save and close the file.
2. Open a new blank document in Word
   Go to Mailings > Start Mail Merge and select Directory (catalog). This merge type does not insert automatic page breaks between records. All records appear one after another in a single document.
3. Select recipients
   Click Mailings > Select Recipients > Use an Existing List. Browse to your sorted Excel file and select the worksheet that contains your data. In the Select Table dialog, check the box labeled First row of data contains column headers.
4. Insert merge fields for the letter content
   Type the static text of your letter. Where you want the recipient names to appear, click Mailings > Insert Merge Field and choose First_Name, Last_Name, or whatever field names you used. Repeat for address and other fields. At the end of the letter, insert a page break by pressing Ctrl+Enter.
5. Insert a nested IF field to break pages between groups
   Place the cursor at the very beginning of the document before the first merge field. Press Ctrl+F9 to insert a pair of curly braces { }. Inside the braces, type the following field code exactly:
   { IF { MERGESEQ } = 1 "" "{ IF { MERGEFIELD GroupID } { MERGEFIELD GroupID } \ MERGEFORMAT }" }
   This code compares the current GroupID to the previous GroupID. When the group changes, Word inserts a page break from the step above. If you do not want the page break on the first record, the outer IF checks whether the merge sequence equals 1 and outputs nothing for the first record.
6. Finish the merge
   Click Mailings > Finish & Merge > Edit Individual Documents. In the Merge to New Document dialog, select All and click OK. Word generates a new document with all records grouped together. Each group starts on a new page because of the IF field logic.
7. Review and remove extra blank pages
   Scroll through the merged document. If you see a blank page at the end of a group, delete it manually. The IF field may produce an extra paragraph mark in some cases. Use Show/Hide (Ctrl+Shift+8) to see paragraph marks and delete the unnecessary ones.

Common Mistakes and Limitations When Using Multiple Recipients per Letter

Blank lines appear between recipients in the same group

If your letter template contains blank paragraphs between merge fields, each record will add those blank lines. Remove unnecessary line breaks in the main document. Use a single paragraph for each address block and insert a line break (Shift+Enter) instead of a paragraph break if you need a new line without extra space.

The IF field does not work and shows the code instead of the result

This happens when you type the curly braces manually instead of using Ctrl+F9. Delete the field and reinsert it using Ctrl+F9. Also verify that the field names inside MERGEFIELD match your data source exactly. Case does not matter, but spelling and spaces do.

Each recipient still appears on a separate page

You likely selected Letters instead of Directory in step 2. The Letters merge type inserts a page break after every record. Go back to Mailings > Start Mail Merge and select Directory. Then rerun the merge.

The merge skips some recipients

Check that your data source is sorted by the Group ID column. If rows for the same group are not consecutive, the IF field will treat them as separate groups and insert extra page breaks. Re-sort the data and try again.

The merged document is very large and slow

A catalog merge with hundreds of groups can produce a document with thousands of pages. Consider splitting the merge into smaller batches. For example, merge only one state or one region at a time. You can also save the merged document as a PDF to reduce file size.

Item	Standard Mail Merge (Letters)	Catalog Merge With IF Field
Recipients per letter	One	Multiple from the same group
Page break behavior	Automatic after each record	Only when the group ID changes
Data source requirement	No grouping column needed	Group ID column required, data must be sorted
Field complexity	Simple merge fields only	Requires nested IF and MERGESEQ fields
Best use case	One letter per person	Household letters, company notices, group invitations

After the merge, you can customize each letter further by adding a salutation that lists all recipients. To do this, insert a MERGEFIELD for First_Name and Last_Name, then type a comma and space, then insert the next MERGEFIELD. Use a conditional IF field to skip the comma for the first recipient in each group. This advanced technique keeps the salutation clean and readable.

The catalog merge with a grouping field is the only reliable way to produce one letter for multiple recipients without using third-party add-ins. Once you understand the IF field logic, you can reuse the same template for any group-based mail merge project. Save the template as a Word template (.dotx) so you can reuse it without rebuilding the fields.