How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.

To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels.

Training: Watch and learn how to print mailing labels with an Excel address list, from your Outlook contacts, or from a new list you’ve created.

Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if …

You've built a list of contacts and other data that you want to use for a Word mail merge. If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge.

Describes how to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet.

In the Mail Merge Recipients dialog box, click the name of the data source and then click Edit. In the Edit Data Source box you can edit or delete existing addresses, or add new entrys.

You've built a list of contacts and other data that you want to use for a Word mail merge. If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge.

Add barcodes using the DisplayBarcode field code, including QR codes, to labels that you make in mail merge.

You can sort the recipient list in chronological order of signups, and then use a Merge record # rule to display the recipient's numbered position in the list. The record number reflects any sorting or filtering …