Document Editing Problems

Fix Doug Robbins Merge Tool Repeating Address Fields in Word

Partner Editor Oct 8, 2026 873 views

Question details

Address merge fields repeat the same data across all output documents when using Doug Robbins' Merge to Individual Documents tool.

How to Fix Doug Robbins Merge Tool Repeating Address Fields in Word

Product: Microsoft Word
Device & OS: not provided
Scenario: Generating individual documents from a mail merge template where the address fields are placed inside text boxes.
Observed behavior: While the 'Preview Results' feature displays the correct individualized data, the final generated documents all contain duplicate address information from the first record.

Before you start

Before modifying your document layout, save a backup copy of your original mail merge template so you can restore it if needed.

Solution 1Recommended

Move Merge Fields from Text Boxes to a Borderless Table

Text boxes exist on a different formatting layer that can confuse third-party generation macros. Moving the fields into a standard table resolves the data retention error while maintaining your layout.

Because text boxes float above the standard document text layer, some macro-based tools fail to iterate to the next data record when scanning inside them. By using a borderless table instead, the tool correctly processes the sequential data.

Select and cut the merge fields

Click inside the text box containing your address merge fields, select all the text, and press Ctrl+X to cut it.

Delete the text box

Click on the outer edge of the now-empty text box so the border becomes solid, then press the Delete key to remove it entirely.

Insert a table

Go to the Insert tab on the top ribbon, click Table, and select a 1x1 grid to insert a single-cell table where your text box used to be.

Paste the merge fields

Click inside the new table cell and press Ctrl+V to paste your address merge fields.

Remove table borders

Select the table, navigate to the Table Design tab, click on Borders, and select 'No Border'. This ensures the gridlines will not appear on your final documents.

Run the merge tool again

Launch the Doug Robbins Merge to Individual Documents tool once more to generate your files. The addresses should now update correctly for each document.

Move Merge Fields from Text Boxes to a Borderless Table

Layout Preservation: A borderless table provides the exact same visual alignment capabilities as a text box without interfering with mail merge automation.

Built-in Mail Merge Alternative

Use Built-in Mail Merge in WPS Writer

If you are tired of dealing with add-in errors and macro glitches, WPS Writer offers a robust built-in Mail Merge feature. It seamlessly handles layout elements and generates individual documents without requiring third-party tools.

1. Open your template: Launch WPS Writer and open your existing document template.
2. Access Mail Merge: Navigate to the References tab on the ribbon and click on Mail Merge to activate the toolset.
3. Insert Data Source: Click 'Open Data Source' and select the Excel spreadsheet containing your address list.
4. Insert Merge Fields: Place your cursor in the desired table or paragraph, click 'Insert Merge Field', and add your address blocks.
5. Merge to Document: Click 'Merge to Different New Document' to reliably generate your individual files without duplicate data errors.

Highly compatible with Microsoft Office formats (.docx, .xlsx) and existing templates.Perfectly handles formatting within tables, headers, and standard paragraphs.No external add-ins or macros required for generating individual documents.Free and lightweight, ensuring smooth performance during bulk document generation.

Frequently Asked Questions

Why do text boxes cause issues with mail merge macros?

Text boxes exist in a separate drawing layer rather than the main text body layer of a document. Custom macros and third-party tools often struggle to index fields inside these isolated layers, causing them to repeat the first record's data instead of cycling to the next.

Will a borderless table look exactly like a text box when printed?

Yes. Once you set the table borders to 'No Border', it will appear exactly like floating text. You can adjust the column width and cell margins to perfectly mimic the dimensions of your original text box.

Why did the 'Preview Results' look correct even when the final merge failed?

The 'Preview Results' feature relies on the word processor's native preview engine, which understands text box layers. However, when a third-party macro executes the actual file generation, it utilizes different background code that fails to update the fields inside those specific layout containers.

How can I align a table to the right side of the page like my text box was?

Select the entire table, go to the Home tab, and click the Right Align paragraph button. Alternatively, you can open Table Properties and adjust the text wrapping to 'Around' to drag and position the table precisely where you need it.

Document & File Issues