How to Mail Merge Multiple Invoice Lines in Microsoft Word
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.

- 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.
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.
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.
Download and install a reputable Many-to-One mail merge add-in compatible with your version of Microsoft Word.
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.
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.
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.
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.

Configure Advanced Word Field Codes
For users who cannot install third-party add-ins, native Word field codes can force a many-to-one merge, though it requires precise and complex configuration.
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. Download and Install: Get the free WPS Office suite from the official website and install it on your computer in minutes.
- 2. Open Your Existing Files: Launch WPS Writer and open your existing Word invoice templates and Excel datasets seamlessly without format loss.
- 3. Edit with Ease: Enjoy a streamlined, user-friendly interface to manage your daily document and spreadsheet tasks effortlessly.

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.




