How to Create and Print Word Labels from an Excel Table
Question details
The user needs to generate and print mailing labels in a word processor using data, such as dates and other fields, stored in an Excel spreadsheet.
- Product
- Microsoft Word / Excel
- Device & OS
- not provided
- Scenario
- Creating a batch of mailing or custom labels using an existing address list or dataset.
- Observed behavior
- Linking specific fields from an Excel table to Word mail-merge labels to selectively print the required records.
Ensure your Excel spreadsheet is formatted correctly as a database, with clear column headers (e.g., Name, Address, Date) in the first row and no blank rows at the top.
Use the Word Mail Merge Feature to Create Labels
The Mail Merge tool in Word allows you to connect an Excel workbook as a data source and dynamically populate label templates with your spreadsheet data.
Mail merge is the most efficient way to generate bulk labels. By linking your Word document to an Excel file, you can pull in specific columns and filter out the rows you do not want to print.
Open a blank Word document. Go to the 'Mailings' tab, click 'Start Mail Merge', and select 'Labels...'. Choose your label vendor and the product number that matches your physical label sheets, then click 'OK'.
Still on the 'Mailings' tab, click 'Select Recipients' and choose 'Use an Existing List...'. Locate and select the Excel workbook containing your data. If prompted, select the specific sheet that holds your table and check 'First row of data contains column headers'.
Click inside the first label on your document. Use the 'Insert Merge Field' button on the 'Mailings' tab to add your desired columns (like Name, Address, or Date). Add spaces or line breaks between the fields as needed to format the label.
Once the first label looks correct, click the 'Update Labels' button in the 'Write & Insert Fields' group. This copies your layout and merge fields to every other label on the page.
If you only want to print specific records, click 'Edit Recipient List' to filter or uncheck rows. Finally, click 'Finish & Merge', choose 'Print Documents...', select 'All' or specific records, and click 'OK' to send the labels to your printer.
How to Create and Print Labels in WPS Writer
WPS Office provides a powerful, built-in Mail Merge feature that seamlessly connects WPS Spreadsheets to WPS Writer, allowing you to generate and print labels quickly and accurately.
- 1. Access Mail Merge: Open a new document in WPS Writer, navigate to the 'References' tab, and click the 'Mail Merge' button to reveal the merge toolbar.
- 2. Open Data Source: Click 'Open Data Source' and browse your computer to select the WPS Spreadsheets (.xlsx) file that contains your label data.
- 3. Insert Fields and Update: Click 'Insert Merge Field' to place your data columns into the document. Format as needed, then apply the layout across your sheet.
- 4. Merge to Printer: Click the 'Merge to Printer' icon on the Mail Merge toolbar to selectively or fully print your generated labels.
Frequently Asked Questions
Why are the dates from my Excel table showing up in the wrong format on my Word labels?
Mail merge imports raw data directly from Excel, which can strip custom formatting. To fix this, you can right-click the date field in Word, select 'Toggle Field Codes', and add a formatting switch (e.g., \@ "MM/dd/yyyy") to force the correct display format, then press F9 to update.
Can I filter the Excel data to print only specific labels instead of the whole list?
Yes. After connecting your Excel list to Word, click 'Edit Recipient List' on the Mailings tab. You can use the checkboxes to manually exclude rows, or use the 'Filter' option to set rules (e.g., only print records from a specific date).
Why is only the first page of my labels printing when I have hundreds of records?
This usually happens if you try to use the standard 'File > Print' command before completing the merge. To print all labels, you must click 'Finish & Merge' on the Mailings tab, then select 'Print Documents'.
How do I fix blank labels appearing in my mail merge?
Blank labels occur if your Excel spreadsheet has completely empty rows within the data range. Open 'Edit Recipient List' and uncheck the blank rows, or clean up your Excel file by deleting any empty rows before starting the merge.
