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.

Outlook can import comma separated value (.csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a .csv file. Here's how:

Create a list based on an Excel (.xlsx) file There are different ways to start a list from an Excel file. You can go to the Lists app in Microsoft 365, SharePoint, or Teams. Choose an app to start …

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.

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. When you use the Word Mail …

Create and send personalized email messages to everyone on your address list with mail merge.

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 …

Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.