Document Editing Problems

How to Mail Merge Multiple Invoice Lines in Microsoft Word

Bushra ParveenBushra Parveen Nov 3, 2026 869 views

Question details

The user needs to group multiple Excel line items under individual invoices, creating separate Word documents or pages for each invoice instead of generating a single page per line item.

How to Mail Merge Multiple Invoice Lines in Microsoft Word
Product
Microsoft Word
Device & OS
not provided
Scenario
Generating separate invoice documents where each invoice contains multiple purchased items or services drawn from an Excel spreadsheet.
Observed behavior
Native mail merge creates a new invoice document for every single Excel row, rather than grouping line items that belong to the same invoice.
Before you start

Ensure your source Excel spreadsheet is strictly sorted by the Invoice Number or Customer ID, as any Many-to-One merge process relies on sequential data to group line items properly.

Solution 1Recommended

Use a Many-to-One Mail Merge Add-in

Using a dedicated add-in is the most practical and convenient method to bypass native limitations and group multiple Excel rows into a single Word invoice.

Microsoft Word's native mail merge wizard processes data row by row, making it difficult to group multiple Excel rows into a single document page. A Many-to-One mail merge add-in extends Word's functionality, automating the grouping process.

1
Install a Many-to-One Add-in

Download and install a reputable Many-to-One mail merge add-in compatible with your version of Microsoft Word.

2
Prepare the Source Data

Open your Excel dataset and verify that all line items belonging to the same invoice share an identical, unique identifier (e.g., Invoice Number) and are sorted consecutively.

3
Configure the Main Document

Open your Word invoice template and launch the installed add-in from the Ribbon. Follow the add-in's specific wizard to select your Excel file as the data source.

4
Map the Grouping Fields

Designate the 'Invoice Number' as the key grouping field. Insert your table layout and map the individual line item fields (like Item Name, Quantity, and Price) into the table.

5
Execute the Merge

Run the merge process through the add-in. It will automatically generate a new document or page for each unique invoice, dynamically populating the table with multiple line items.

Use a Many-to-One Mail Merge Add-in
Free Microsoft Office alternative

Experience Seamless Document Management with WPS Office

If you are tired of struggling with complex field codes and expensive add-ins in Microsoft Word, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly environment for all your spreadsheet and document creation needs, completely free of charge.

  1. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer in minutes.
  2. 2. Open Your Existing Files: Launch WPS Writer and open your existing Word invoice templates and Excel datasets seamlessly without format loss.
  3. 3. Edit with Ease: Enjoy a streamlined, user-friendly interface to manage your daily document and spreadsheet tasks effortlessly.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsLightweight software that loads quickly and operates smoothly on any deviceIntuitive and familiar Ribbon interface for a zero learning curveBuilt-in PDF editor and extensive free template library
microsoft office alternative - wps office

Frequently Asked Questions

Why does standard mail merge create a new page for every item?

Microsoft Word's default mail merge is designed as a 'One-to-One' operation. It processes one row of Excel data per document page or label, meaning it does not natively recognize how to group multiple rows (like invoice items) onto a single page without special instructions.

Can I use the 'Directory' merge type for invoices instead?

Yes, the 'Directory' (or Catalog) merge type lists items sequentially without forcing a page break after each row. However, to start a new page automatically when the invoice number changes, you still need to implement complex IF and SET field codes.

Are there free Many-to-One mail merge add-ins available?

While there are some community-created macros and free add-ins available on tech forums, the most reliable and user-friendly Many-to-One solutions are often paid, third-party utilities. Always ensure you download add-ins from trusted developers.