Document Editing Problems

How to Fix NextRecord Field Not Working in Word Mail Merge

Aamir Naveed Akram Oct 10, 2026 870 views

Question details

The user needs to use the NextRecord field in a Word mail merge but encounters formatting and sequencing issues when placing the fields inside text boxes or complex fixed tables.

How to Fix NextRecord Field Issues in Word Mail Merge

Product: Microsoft Word
Device & OS: not provided
Scenario: Structuring a complex mail merge document where data fields must fit into specific table cells or text boxes without breaking the layout.
Observed behavior: The NextRecord field fails to function reliably inside text boxes, and merging multiple records into standard tables causes layout disruption if cells are not rigidly fixed.

Before you start

Verify that your connected data source contains properly formatted column headers without blank rows, and save a backup copy of your main merge document before restructuring the layout.

Solution 1Recommended

Use a Directory Mail Merge for Multiple Records

Switching to a Directory type mail merge is the most reliable way to display multiple records in a single table without relying on problematic NextRecord fields.

The NextRecord field is designed primarily for standard letters and labels on the main text layer. When placed inside text boxes or complex tables, it often fails to trigger the sequence correctly. A Directory merge repeats the entire document layout for each record sequentially, making it ideal for lists, catalogs, and tables.

Change the merge document type

Navigate to the Mailings tab, click 'Start Mail Merge', and select 'Directory' from the dropdown menu to change the behavior of the output.

Set up a single table row

Insert a table with a single row containing your desired merge fields. Do not include the table headers in this document, as they would repeat for every record (headers can be inserted later into the final generated document).

Complete the merge process

Click 'Finish & Merge' and select 'Edit Individual Documents'. The software will generate a new document containing a continuous list of rows representing all your records.

Use a Directory Mail Merge for Multiple Records

Avoid Text Boxes for Merge Fields: For best results, avoid placing merge fields inside text boxes entirely. Text boxes exist on a separate drawing layer of the document and frequently ignore sequential field commands.

Solution 2

Configure Fixed-Width Tables and Pre-build Fields

If you must use a standard table layout with the NextRecord field, ensure your table cells are locked to a fixed width so large data sets do not break the document design.

Efficient Document Processing

Easily Create Complex Mail Merges with WPS Writer

WPS Writer provides an intuitive Mail Merge feature that handles multiple records smoothly, allowing you to quickly generate labels, directories, and letters while bypassing complex NextRecord limitations.

1. Launch the Mail Merge feature: Open WPS Writer, navigate to the References tab, and click the Mail Merge button to reveal the dedicated merge toolbar.
2. Import your data source: Click 'Open Data Source' and browse your computer to select the Excel spreadsheet or database containing the records you wish to merge.
3. Insert merge fields: Place your text cursor where you want the data to appear, click 'Insert Merge Field', and map the corresponding column headers.
4. Merge to a new document: Click 'Merge to New Document' to automatically generate a complete, correctly sequenced file containing all of your records.

Fully compatible with Microsoft Word .docx formatsIntuitive Mail Merge wizard for labels, letters, and directoriesSeamlessly connects to Excel spreadsheets and CSV data sourcesFree, lightweight, and incredibly easy to navigate

microsoft office alternative - wps office

Frequently Asked Questions

What is the purpose of the NextRecord field in a mail merge?

The NextRecord field instructs the word processor to advance to the next row of data in your connected spreadsheet without forcing a page break. It is primarily used for creating documents with multiple records on a single page, such as custom mailing labels.

Why does the NextRecord field fail when placed inside a text box?

Text boxes operate on a distinct drawing layer that is separate from the main text layer of the document. Mail merge sequencing fields like NextRecord often fail to execute properly because they cannot communicate across these different document layers.

Can I use Sequence fields instead of NextRecord to number tickets?

Yes. If your goal is to generate sequentially numbered tickets and you do not require an external spreadsheet database, you can use the SEQ (Sequence) field to automatically generate consecutive numbers throughout your document layout.

Document & File Issues