Template Issues

How to Set Up Word Mail Merge for 30 A4 Labels per Sheet

Aamir Naveed AkramAamir Naveed Akram Nov 2, 2026 869 views

Question details

The user needs to set up a mail merge project for a physical A4 sheet containing 30 labels, but a generic template is not explicitly listed.

How to Set Up Word Mail Merge for 30 A4 Labels per Sheet
Product
Microsoft Word
Device & OS
not provided
Scenario
Creating and printing a batch of mailing labels using a standard 30-label A4 sheet layout.
Observed behavior
Word does not display a generic 30-label template by default, requiring the user to locate a compatible template like Avery L7158 and manually tweak the dimensions.
Before you start

Ensure you have your Excel spreadsheet or data source ready with contact information, and keep a physical sheet of your 30-up A4 labels handy for layout comparison.

Solution 1Recommended

Use the Avery L7158 Template for 30 A4 Labels

Select the widely compatible Avery L7158 template in Word's label options to correctly format 30 labels per A4 sheet.

Although a generic '30 labels per sheet' option might not appear immediately, the Avery L7158 template is the industry standard for this exact layout. You can select this template and make minor adjustments to fit off-brand label sheets perfectly.

1
Access Mail Merge Labels

Open Microsoft Word, go to the 'Mailings' tab on the top ribbon, click 'Start Mail Merge', and select 'Labels' from the drop-down menu.

2
Select Label Vendor and Template

In the Label Options dialog box, ensure the Page size is set to A4. Choose 'Avery' or 'Avery A4/A5' from the 'Label vendors' drop-down list.

3
Choose the 30-Label Format

Scroll through the 'Product number' list, select 'L7158', and click 'OK' to apply the template to your document.

4
Adjust Dimensions if Necessary

Compare the on-screen table layout with your physical labels. If they differ slightly, select the table, navigate to the 'Layout' tab under Table Tools, and adjust the cell height, width, and margins to match your specific label sheet.

Use the Avery L7158 Template for 30 A4 Labels
Testing Your Label Alignment: Always print a test page on a plain sheet of A4 paper first. Hold the printed paper up to the light against your blank physical label sheet to verify the alignment before printing on the actual labels.
Efficient Mail Merge with WPS Office

Create Mail Merge Labels Easily in WPS Writer

WPS Office offers a highly intuitive Mail Merge wizard that is fully compatible with Microsoft Word documents and Excel data sources, making label creation quick and hassle-free.

  1. 1. Open WPS Writer: Launch WPS Writer, navigate to the 'References' tab on the ribbon, and click on 'Mail Merge'.
  2. 2. Import Your Data Source: Click 'Open Data Source' to browse and import your Excel spreadsheet containing the label data.
  3. 3. Set Up Label Layout: Configure your 30-label layout using the document table and click 'Insert Merge Field' to place your desired contact information into the first label.
  4. 4. Update and Print: Copy the setup to all labels on the page, then click 'Merge to Printer' or 'Merge to New Document' to finalize your batch of A4 labels.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsBuilt-in Mail Merge features for intuitive label generationCustomizable label dimensions for any standard or custom A4 sheet layoutFree, lightweight, and fast-loading office suite
microsoft office alternative - wps office

Frequently Asked Questions

What are the standard dimensions of an Avery L7158 label?

The standard Avery L7158 label measures 64 mm x 26.7 mm (approximately 2.52 x 1.05 inches). These are arranged in 3 columns and 10 rows on an A4 sheet.

How do I fix text cutting off at the edges of my labels?

If text is too close to the edge, select the entire label table, right-click and choose 'Table Properties'. Go to the 'Cell' tab, click 'Options', and slightly increase the left and right cell margins.

Why is my mail merge only filling the very first label on the sheet?

After setting up the merge fields in the first label, you must click the 'Update Labels' button in the Mailings tab. This action copies your formatting and fields to all other labels on the sheet and adds the necessary '<<Next Record>>' rule.

Can I use a custom Excel spreadsheet for my mail merge label data?

Yes. Before starting the mail merge process, ensure your Excel data is organized neatly with clear column headers (e.g., First Name, Last Name, Address) in the first row, without any blank rows at the top.