Formatting Issues

How to Format Two Names on Separate Lines in Word Mail Merge

Adam Davis Oct 14, 2026 871 views

Question details

The user needs to configure a Word mail merge to display two recipient names (such as a couple sharing an address) on separate lines rather than on a single line.

How to Format Two Names on Separate Lines in Word Mail Merge

Product: Word
Device & OS: not provided
Scenario: Creating customized envelopes or letters for couples sharing the same address using the Mail Merge feature.
Observed behavior: The user wants to control the line breaks between multiple names and adjust the font, size, and alignment of the merged text in Word.

Before you start

Ensure your recipient list is updated in an Excel spreadsheet with clear, separate column headers for each person's first and last name.

Solution 1Recommended

Set Up Separate Columns and Format in Word

This is the recommended approach for placing two names on separate lines, giving you complete control over spacing and text formatting.

To achieve distinct lines for each name, your data source must handle the names individually. You will need to structure your Excel columns correctly before pulling the data into Word.

Prepare your Excel data source

Open your recipient list and create separate columns for each individual (e.g., 'First Name 1', 'Last Name 1', 'First Name 2', 'Last Name 2'). Ensure both individuals share the same address data in the corresponding row.

Start the Mail Merge in Word

Open your Word document, navigate to the Mailings tab, click 'Start Mail Merge', and select your preferred document type (like Envelopes or Letters). Choose 'Select Recipients' to import your Excel workbook.

Insert merge fields on separate lines

Click 'Insert Merge Field' from the Mailings tab. Insert the fields for the first person, press the Enter key on your keyboard to start a new line, and then insert the fields for the second person.

Format the merged fields

Highlight the inserted merge fields in your document. Navigate to the Home tab to change the font style, font size, and text alignment to match your preferred envelope or letter design.

Preview and finish

Return to the Mailings tab and click 'Preview Results' to ensure the names appear on separate lines with the correct formatting. Once verified, click 'Finish & Merge'.

Set Up Separate Columns and Format in Word

Formatting Note: Formatting applied in the Excel data source will not carry over to Word. Always format the actual merge fields within the Word document itself.

Solution 2

Combine Names on a Single Line

Use this alternative method if you prefer both names to appear together on the same line, such as 'John & Jane Smith'.

WPS Writer Mail Merge

Perform Seamless Mail Merges with WPS Writer

WPS Writer features a powerful and intuitive Mail Merge tool that allows you to easily connect spreadsheets, organize recipient details on separate lines, and perfectly format your letters or envelopes.

1. Open WPS Writer: Launch WPS Writer and create a new document or open your existing letter or envelope template.
2. Import data source: Navigate to the Mailings tab and click 'Open Data Source' to select your Excel spreadsheet containing the recipient names.
3. Insert merge fields: Click 'Insert Merge Field' to add the first person's name, press Enter for a new line, and then insert the second person's name.
4. Apply formatting: Highlight the newly inserted fields and use the tools on the Home tab to adjust the font, size, and paragraph alignment.
5. Complete the merge: Click 'Preview Results' to verify the layout, then click 'Merge to New Document' or 'Merge to Printer' to finish.

Fully compatible with Microsoft Word documents and Excel recipient listsIntuitive Mail Merge wizard for quick and flawless setupAdvanced formatting options for personalized envelopes and letters

microsoft office alternative - wps office

Frequently Asked Questions

Why is my mail merge formatting from Excel not carrying over to Word?

Word does not automatically import text formatting (such as fonts, sizes, or colors) from the Excel data source. You must highlight the inserted merge fields in the Word document and apply the desired formatting directly using the Home tab.

Should I create separate Spouse/Partner columns in my Excel list?

Yes, if you want full control to place each person on a separate line in Word, it is best to create separate 'First Name' and 'Last Name' columns for both individuals in your Excel spreadsheet, keeping them on the same row with their shared address.

How do I fix mail merged envelopes that are centered and using the wrong font?

To fix this, highlight the merge fields in your Word envelope template before completing the merge. Go to the Home tab to change the font and size, and use the paragraph alignment buttons to align the text to the left or exactly where you need it.

How can I preview my formatting before printing?

On the Mailings tab, click the 'Preview Results' button. This allows you to toggle through your recipient list and see exactly how the names, line breaks, and formatting will look for each individual before you print.

Document & File Issues