Fix Mail Merge Inserting Only First Paragraph from Excel Cell
Question details
The user is experiencing an issue during a mail merge where only the first paragraph of a multi-paragraph text block from an Excel cell is inserted into the Word document.

- Product
- Word Processing and Spreadsheets
- Device & OS
- not provided
- Scenario
- Performing a document mail merge using an Excel spreadsheet containing multi-paragraph text blocks as the data source.
- Observed behavior
- Only the first paragraph from the source Excel cell appears in the generated document, truncating the rest of the text block.
Ensure your spreadsheet data source is completely saved and closed before running the mail merge in your word processor to prevent data refresh errors.
Paste Text Directly into Excel Cell Edit Mode
Modify how you paste the multi-paragraph text into your spreadsheet so that paragraph marks are converted into line breaks within a single cell.
When you paste multi-paragraph text into Excel normally, it often splits across multiple rows or creates formatting that the mail merge engine misinterprets. By forcing the text into a single cell's edit mode, paragraph marks are stored safely as internal line breaks.
Locate the target cell in your spreadsheet. Double-click the cell, or select it and press F2 on your keyboard to activate the blinking text cursor inside the cell.
With the cursor active inside the cell, paste your multi-paragraph text. This ensures all text is kept within the single cell and paragraph marks are converted to line breaks (similar to pressing Alt+Enter).
Press Enter to confirm the cell contents, save your spreadsheet file, and run the mail merge process again in your word processor. The complete text block should now appear.

Easily Manage Mail Merge and Data with WPS Office
WPS Office provides a highly compatible and integrated mail merge feature. You can effortlessly link WPS Spreadsheet data to WPS Writer documents to create bulk letters, labels, and emails without text truncation issues.
- 1. Prepare Data in WPS Spreadsheet: Open WPS Spreadsheet, ensure your multi-line text is correctly formatted within cells using Alt+Enter, and save the file.
- 2. Start Mail Merge in WPS Writer: Open your template in WPS Writer, navigate to the 'References' tab, and click 'Mail Merge' to activate the tools.
- 3. Select Data Source: Click 'Open Data Source', browse to your saved WPS Spreadsheet file, and import it into your document.
- 4. Insert Fields and Merge: Place your cursor in the document, click 'Insert Merge Field', select your data column, and click 'Merge to New Document' to generate the complete files.

Frequently Asked Questions
Why does my mail merge cut off text from a spreadsheet cell?
If text is pasted into an Excel cell without being in edit mode, it may be split across rows or contain line breaks that the mail merge engine misinterprets as the end of a record. Pasting directly inside the cell (using F2) ensures the entire block is treated as a single cell value.
How do I add manual line breaks inside a single cell?
To add a line break without moving to the next row, double-click the cell to edit it, place your cursor where you want the break, and press Alt + Enter on your keyboard.
Can I keep my paragraph indentation when merging from a spreadsheet to a document?
Spreadsheet cells do not natively support complex paragraph formatting like first-line indentation. To maintain strict formatting, you should apply paragraph styles directly to the merge field in your word processor template.




