Formatting Issues

How to Order Word Mail Merge Labels by Column

Chanuka GeekiyanageChanuka Geekiyanage Nov 4, 2026 870 views

Question details

The user needs to change the mail merge sequence for labels so that the data fills vertically down columns rather than horizontally across rows.

How to Order Word Mail Merge Labels by Column
Product
Microsoft Word
Device & OS
not provided
Scenario
Creating mail merge labels and attempting to adjust the print order to match specific physical label layouts or sorting requirements.
Observed behavior
By default, Word mail merge populates label templates left-to-right across each row before moving to the next row, ignoring requests for column-first filling.
Before you start

Ensure you have saved a backup copy of your original mail merge document and that your data source (such as an Excel spreadsheet) is finalized before modifying the layout or sorting order.

Solution 1Recommended

Convert Label Merge to Directory Merge with Columns

Modifying the document layout to a Directory merge using newspaper-style columns allows the data to naturally flow vertically down the page.

Because the standard Mail Merge 'Labels' feature is built using Word tables, it strictly fills cells from left to right. By switching to a 'Directory' merge (which stacks records continuously) and applying page-level columns, you can force the text to flow downwards first.

1
Prepare the Main Document

Open your existing label mail merge document. Delete all label placeholders and "<<Next Record>>" rules except for the very top-left label entry.

2
Change Merge Type to Directory

Navigate to the 'Mailings' tab on the ribbon. Click 'Start Mail Merge' and select 'Directory' from the dropdown menu instead of 'Labels'.

3
Apply Newspaper-Style Columns

Go to the 'Layout' (or 'Page Layout') tab, click 'Columns', and select 'More Columns'. Set the number of columns to match your label sheet, and adjust the spacing to perfectly align with the physical gaps between your labels.

4
Complete the Merge

Ensure your merge fields are correctly placed in the top-left section. Go back to 'Mailings', click 'Finish & Merge', and select 'Edit Individual Documents' to generate the new column-ordered labels.

Convert Label Merge to Directory Merge with Columns
Layout Adjustments: You may need to tweak the paragraph spacing or page margins of your single block to ensure the generated directory output perfectly aligns with your physical label sheets.

Easily Create and Format Mail Merge Labels in WPS Office

WPS Writer provides robust Mail Merge features that are fully compatible with Microsoft Word documents, allowing you to easily manage directory merges, custom columns, and data sources to achieve column-first label printing.

  1. 1. Open Document in WPS Writer: Launch WPS Writer, open your label template, and navigate to the 'References' tab, then click 'Mailings'.
  2. 2. Set Up a Directory Merge: Click 'Start Mail Merge' on the ribbon and choose 'Directory'. Clear out all entries except the first one in the top-left corner.
  3. 3. Configure Page Columns: Switch to the 'Page Layout' tab, click 'Columns', and define the number of columns and spacing to match your physical label sheet grid.
  4. 4. Merge and Output: Insert your desired merge fields into the first block, then click 'Merge to New Document' to generate your labels sorted down the columns.
Highly compatible with Microsoft Word .docx formats and Excel data sources.Intuitive Mail Merge wizard for labels, letters, and directories.Easily apply advanced page layout and column formatting.Free, lightweight, and fast document processing alternative.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Word always fill mail merge labels across rows first?

Word's label feature is fundamentally built on standard document tables. Because mail merge populates table cells systematically from left-to-right, row-by-row, it cannot natively skip to the cell below it until the current row is completely filled.

Can I use the 'Next Record' rule to force column ordering in a table?

No, the 'Next Record' rule simply commands Word to pull the next row of data from your source file. If your template is structured horizontally as a table, it will still place that next record in the adjacent horizontal cell. Altering the page flow into columns via a Directory merge is required.

Will changing to a Directory merge mess up my label sizes?

It can if not configured carefully. When using a Directory merge with page columns, you must ensure that your column widths, margins, and the exact paragraph height within the single directory entry perfectly match the physical dimensions of your label stickers.