How to Set Up Word Mail Merge for 30 A4 Labels per Sheet
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.

- 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.
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.
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.
Open Microsoft Word, go to the 'Mailings' tab on the top ribbon, click 'Start Mail Merge', and select 'Labels' from the drop-down menu.
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.
Scroll through the 'Product number' list, select 'L7158', and click 'OK' to apply the template to your document.
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.

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. Open WPS Writer: Launch WPS Writer, navigate to the 'References' tab on the ribbon, and click on 'Mail Merge'.
- 2. Import Your Data Source: Click 'Open Data Source' to browse and import your Excel spreadsheet containing the label data.
- 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. 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.

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.




