Fix Microsoft Word Mail Merge Fields Truncated Over 255 Characters
Question details
The user is looking for a solution to prevent data truncation when importing Excel fields containing more than 255 characters into a Word mail merge.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Creating a mail merge document in Word using an Excel spreadsheet that contains long descriptions or notes.
- Observed behavior
- Text fields containing more than 255 characters are automatically cut off or truncated in the resulting merged Word document.
Ensure your Excel data source is saved and closed before attempting a mail merge, and identify exactly which columns contain text exceeding the 255-character limit.
Use Doug Robbins's Merge Tools Add-in
Since Microsoft Word has a native limitation for OLE DB connections, using a specialized macro add-in is one of the most reliable workarounds.
Microsoft Word defaults to an OLE DB connection when linking to Excel, which restricts standard text fields to 255 characters. Doug Robbins, an Office MVP, created a highly regarded set of Merge Tools that bypasses these native restrictions.
Search for and download Doug Robbins's Merge Tools add-in from a reputable Microsoft Office MVP resource or community forum.
Extract the downloaded files and place the template (.dotm) file into your Word Startup folder so that the tools load automatically when you launch the application.
Open your main mail merge document, navigate to the newly added Merge Tools tab on your Word ribbon, and select the appropriate merge type to process your long-text data without truncation.

Connect to Excel via Dynamic Data Exchange (DDE)
Changing the way Word connects to Excel from the default OLE DB to DDE forces Word to read the data exactly as it appears in Excel, bypassing the truncation limit.
Switch to WPS Office for Seamless Document Management
Frustrated by data limitations and complex workarounds in Microsoft Word? WPS Office is a free, lightweight, and highly compatible alternative that offers powerful word processing, spreadsheets, and presentation tools in one unified workspace. It seamlessly supports all Microsoft Office formats, allowing you to handle your daily tasks without friction.
- 1. Download and Install: Visit the official WPS website, download the free installer, and complete the lightweight installation in just a few minutes.
- 2. Open Existing Files: Launch WPS Office and open your .docx and .xlsx files directly; WPS handles Microsoft formats with zero conversion needed.
- 3. Enjoy a Unified Workspace: Edit your documents, spreadsheets, and PDFs effortlessly within a single, tabbed application window.

Frequently Asked Questions
Why does Word mail merge truncate text at 255 characters?
By default, Microsoft Word connects to Excel using the OLE DB provider. This provider samples the first few rows of your Excel sheet to determine the data type. If it classifies the column as a standard text field instead of a memo field, it enforces a strict 255-character limit.
Can I format my Excel column differently to prevent truncation without add-ins?
You can try forcing the OLE DB provider to recognize the column as a 'Memo' type. To do this, move a row that contains more than 255 characters to the very top of your Excel dataset (immediately below the header row). This often tricks the connection into allowing longer text.
Are there any downsides to using the DDE connection workaround?
Yes. Dynamic Data Exchange (DDE) is an older legacy technology. It requires the Excel application to be open during the merge and may struggle with newer Excel features, complex formulas, or extremely large datasets.




