How to Add Next Record in Word Mail Merge, Step by Step

To add a Next Record rule in Word, place the cursor where the next recipient’s information should begin, then choose Mailings > Rules > Next Record. Word advances to the next selected recipient at that point in the document. This is useful for putting multiple records on one page, especially mailing labels; it is usually unnecessary when each letter or envelope is meant to use one recipient per document.

Before adding the rule, connect your mail merge to a recipient list and decide how many records should appear on each page. A Next Record rule changes which recipient supplies the merge fields that follow it, so its position matters. The instructions below are for Word for Microsoft 365 on Windows.

What You’ll Need

Word for Microsoft 365 desktop. Word for the web does not provide the full desktop mail-merge rule tools, so open the document in the desktop app to add or edit this rule.
A connected recipient list. This can be an Excel workbook, an Outlook contacts list, or another supported data source. Check that the list has clear column headings and the recipients you intend to merge.
A mail-merge document with a layout. For example, a page of labels, a directory, or a page designed to show several records. If you want one letter per recipient, you generally do not need to add Next Record manually.

Step-by-Step

Open the merge document and connect its recipient list. In Word, open the document, select the Mailings tab, and choose Select Recipients. Pick an existing list or use the appropriate option to connect a data source. If Word asks you to choose a sheet or table, select the one containing the recipient data and confirm that the first row contains column headings. Use Edit Recipient List to check which records are included, filtered, or excluded. The rule moves through the records selected for the merge, not necessarily every row in the original file.
Choose the layout and identify where the record should advance. Decide where each recipient’s content starts. In a label sheet, each label after the first is a new recipient position. In a custom directory or multi-record page, it may be the start of a new block. The first block normally uses the current recipient; insert Next Record at the beginning of each later block, before that block’s merge fields. Do not put it before the first recipient’s fields unless you deliberately want to skip the first selected record.
Put the insertion point in the right place. Click at the beginning of the second recipient’s block or label, before its name, address, or other merge fields. If the document uses a table, click in the correct cell and place the cursor before the first field in that cell. The rule is a Word field, not ordinary typed text. It needs to be inserted in the document at the point where the merge should advance.
Insert the rule from the Mailings ribbon. Select Mailings > Rules > Next Record. Word inserts a Next Record field at the cursor. Depending on field display settings, it may appear as a shaded field or as a label such as «Next Record». Do not type the words “Next Record” yourself; typed text will not advance the merge. If the rule appears in the wrong location, undo the insertion or cut the field, click at the correct point, and insert it again.
Add or verify the merge fields after the rule. With the cursor after the Next Record field, add the recipient fields using Mailings > Insert Merge Field, choosing the appropriate column names. For example, a label might contain the rule followed by «First Name», «Last Name», and «Address». The first label usually has those merge fields without a Next Record rule; subsequent labels need the rule before their fields so each label uses a different recipient. Keep the rule ahead of all fields that should use the new record.
For a label document, use Update Labels when available. If you created labels through Mailings > Start Mail Merge > Labels, design the first label, then select Update Labels. Word copies the first label’s layout to the other label positions and normally adds the Next Record rules in the later labels. Inspect the copied labels rather than adding another rule automatically: duplicate rules can skip recipients. If you are building a custom table rather than using Word’s label layout, insert each rule manually at the start of each later record block.
Preview the sequence before finishing the merge. Select Mailings > Preview Results, then use the left and right recipient arrows on the Mailings tab to inspect the output. In a page with several records, confirm that each successive block shows a different recipient in the expected order. Check the first and last labels or blocks and at least one page break. Use Finish & Merge only after the sequence and layout look right; for a test, choose Edit Individual Documents and merge a small record range if that option is available in your workflow.

Word processes merge fields in document order. When it encounters Next Record, it moves to the next selected recipient for the fields that follow. For example, if a page contains three labels, the first label uses recipient 1, the second starts with Next Record and uses recipient 2, and the third starts with another Next Record and uses recipient 3. The next page continues with the next available selected records.

Common Mistakes

Adding the rule to the first record block. This advances before the first block’s fields are filled and can make the first selected recipient disappear from the output. Leave the first block without Next Record unless skipping that recipient is intentional.
Putting it after the merge fields. Word uses the current record for fields it has already encountered. If the rule comes after the name and address, those fields do not switch to the next recipient. Place it before the fields for the next block.
Typing the rule as plain text. The words “Next Record” do not perform a merge action. Insert the command from Mailings > Rules.
Adding a second rule where Word already inserted one. The label wizard’s Update Labels command usually creates the rule for later labels. An extra Next Record can skip one or more recipients, so review the label layout before inserting more.
Using it in a one-recipient-per-letter merge. Word already starts each merged letter with the next recipient. A manual Next Record can skip a person or create confusing results. Remove it unless the document intentionally includes multiple recipients in one merged document.
Assuming the rule changes the recipient list. It advances through the records currently included in the merge. It does not sort the source list or undo filters and exclusions in Edit Recipient List.

Tips

Make a backup before changing a finished layout. Save a copy of the Word document before editing label grids or directory layouts. You can then compare the original if a rule is moved, duplicated, or deleted by mistake.
Test a small group first. Preview a few adjacent recipients and, when practical, merge only a small selection to a new document. This makes it easier to spot skipped records, repeated records, and problems at page boundaries before producing a large batch.
Keep each record block consistent. Use the same field order and spacing in every label or block. If one label has an extra merge field or a different structure, it can be harder to tell whether a mismatch comes from the data or the rule position.
Use Preview Results to inspect actual values. While preview is on, Word shows recipient data in place of field names. Toggle Preview Results off to return to editing the merge fields. Do not judge the finished output only by how the field names look in the template.
Remember that filters change the sequence. If you filter recipients or sort the list, the next record is the next person in that resulting sequence. Confirm the recipient order in Edit Recipient List before concluding that the rule skipped someone.

Troubleshooting

The same recipient appears in every label. Check whether the later labels actually contain a Next Record field at their beginning. If you used a custom table, insert a rule in every later record position. If you used Update Labels, inspect the generated labels and update the layout again if the first label was changed after copying.

Recipients are skipped. Look for two Next Record fields before a block’s merge fields, including a rule already created by the label wizard. Remove the unintended duplicate, then preview again. Also check whether records are hidden by a filter or excluded in Edit Recipient List; Word advances through the selected recipients only.

The first person is missing. Check whether a Next Record field appears before the first block’s fields. If it does, remove it unless skipping the first selected person was deliberate. Then preview the first record again.

The rule appears as text or the command is unavailable. Make sure the file is open in the Word desktop app and that the cursor is in the document body, not a menu or dialog. Insert the field through Mailings > Rules > Next Record, rather than typing its name. On Word for Mac, the Mailings ribbon and rule controls may be arranged differently; look for Rules on the Mailings tab. If the command is not present in your build, use Word for Microsoft 365 on Windows to edit the merge rule.

The merge runs out of records near the end of a page. A page may have more record positions than remaining recipients, especially when the recipient count is not divisible by the number of blocks per page. Check the final page in the merged document; unused positions at the end can be expected. If a recipient is missing earlier in the document, review the rule count and selected recipient list.

Frequently Asked Questions

What does Next Record do in Word mail merge?
It tells Word to move to the next selected recipient for the merge fields that follow the rule. It is commonly used when multiple records appear in one merged document, such as a sheet of labels.

Where is the Next Record command?
In Word for Microsoft 365 on Windows, place the cursor in the document and select Mailings > Rules > Next Record. The Mac ribbon may be arranged differently, but look for the Rules menu on the Mailings tab.

Should the first label have a Next Record rule?
Usually not. The first label uses the current recipient. Add the rule at the start of each following label so that each position uses the next person in the selected list.

Does Next Record create a new page?
No. It changes the recipient used by subsequent merge fields; it does not add a page break or start a separate merged document. Add page breaks or choose a suitable document layout separately.

Do I need Next Record for one letter per recipient?
Usually no. Word already advances to the next recipient as it creates each merged letter. Add the rule only when you intentionally want more than one recipient’s information in a single merged document.

Can I add Next Record in Word for the web?
Use the Word desktop app for creating or changing mail-merge rules. Open the document in desktop Word, insert the rule from the Mailings tab, and preview the merge there before producing the final documents.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.