Printing Problems

How to Convert an Excel Address List into Mailing Labels

Amos Gikunda Sep 30, 2026 868 views

Question details

The user needs to generate printable mailing labels using names and addresses stored in an Excel workbook.

Word mail merge labels with Excel fields and Update Labels

Product: Excel / Word
Device & OS: not provided
Scenario: Creating bulk mailing labels from an existing contact data source for printing.
Observed behavior: The user wants to format Excel records into printable labels by connecting the spreadsheet to a word processor using the Mail Merge function.

Before you start

Ensure your Excel spreadsheet has clear column headings (such as First Name, Last Name, Address, City, State, ZIP) in the first row, and format postal codes as text so you do not lose any leading zeros.

Solution 1Recommended

Use Mail Merge in Word to Create Labels from Excel

Use the built-in Mail Merge feature to connect your Excel address list to a Word document and generate perfectly formatted mailing labels.

Mail Merge acts as a bridge between your spreadsheet and your word processor. By setting up a label template once, the software automatically pulls each contact's details from your Excel list and formats them into individual labels ready for printing.

Prepare and close your Excel data

Open your address list in Excel, ensure all data is organized with clear column headers, format ZIP codes as text, and save the file. You must close the Excel workbook before proceeding to prevent file locking issues.

Select the label format in Word

Open a blank Word document. Navigate to the 'Mailings' tab, click 'Start Mail Merge', and select 'Labels'. Choose your specific label vendor and product number from the dialog box, then click 'OK'.

Connect your Excel list

Still under the 'Mailings' tab, click 'Select Recipients' and choose 'Use an Existing List'. Browse to your saved Excel address file, open it, and select the specific sheet containing your contact data.

Insert merge fields and update labels

Click into the first label on your page. Click 'Address Block' or 'Insert Merge Field' to place the contact information exactly how you want it. Once the first label is formatted, click the 'Update Labels' button to copy this layout to the rest of the labels on the page.

Preview and print

Click 'Preview Results' to verify that the names and addresses look correct. Finally, click 'Finish & Merge' and select 'Print Documents' to send your newly created mailing labels directly to your printer.

Formatting Tip: If you notice spacing issues during the preview stage, you can toggle 'Preview Results' off, adjust the spacing in the first label, and click 'Update Labels' again to apply the fix globally.

Create Mailing Labels Easily with WPS Office

WPS Office seamlessly integrates WPS Spreadsheet and WPS Writer, making it incredibly simple to create bulk mailing labels using the powerful Mail Merge feature without switching between disconnected apps.

1. Prepare data in WPS Spreadsheet: Organize your address list with clear headers in WPS Spreadsheet, save the file as .xlsx, and close it.
2. Start Mail Merge in WPS Writer: Open WPS Writer, navigate to the 'Mailings' tab, and click 'Mail Merge' to activate the tools.
3. Open Data Source: Click 'Open Data Source', browse to your saved WPS Spreadsheet address list, and import your contacts.
4. Insert fields and Print: Insert the required merge fields into your label layout, preview the data, and click 'Merge to Printer'.

Seamless Mail Merge integration between WPS Spreadsheet and WPS Writer.Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formats.Free, lightweight, and fast office suite.User-friendly interface for bulk printing labels, letters, and envelopes.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my ZIP codes missing leading zeros in the mail merge?

By default, Excel treats ZIP codes as numerical values and drops any leading zeros (e.g., 01234 becomes 1234). To fix this, format the ZIP code column as 'Text' in your Excel spreadsheet before importing the data into your word processor.

Can I filter which contacts get printed from my Excel list?

Yes. After connecting your Excel list in the Mailings tab, click 'Edit Recipient List'. A dialog box will appear allowing you to uncheck specific names, sort the list, or filter by criteria such as City or State.

Why is only the first label showing my merge fields?

When setting up labels, you configure the layout on the first label only. Once your fields (like First Name, Last Name, Address) are placed, you must click the 'Update Labels' button in the Mailings tab to populate the remaining labels on the page.

Document & File Issues