Connect the Excel worksheet to the Word labels Related: 12 Excel Interview Questions and Answers To Help You Prepare 3. After you find them, click 'OK.' After this, the label outlines should appear. This feature allows you to choose the label brand and product number you're going to use. On the left-hand side, click 'Start Mail Merge.' When the drop-down menu appears, select 'Labels.' Then a window titled 'Label Options' appears. Locate and click on the 'Mailings' tab at the top center of the menu ribbon. Here's an example of a completed list using first and last names:Īfter you've completed the Excel address list, open up a new Word document. If you're completing a mix of both, consider creating the company address labels on a separate worksheet since you're going to use different headers. You may also choose to include titles in your address labels, such as 'Mr.' 'Ms.' or 'Dr.' In addition, if the business is sending mail to other businesses, they can omit the 'First name' and 'Last name' headers and include a 'Company name' header instead. Whether you already have the information in a worksheet or you're inputting each address manually, make sure you have the following headers included, so that each required part of the address is complete: Sometimes companies keep their customers' names and addresses in an Excel worksheet, which makes it very convenient to create address labels since all of their information is already in Excel. Related: How To Include Excel Skills on Your Resume How to make address labels in Excelīelow are the steps you can follow if you're interested in making address labels using Excel and Microsoft Word mail merge: 1. The mail merge feature allows users to create sheets of mailing labels you can print using the names and addresses in an Excel worksheet file. You can create hundreds or thousands of mailing labels in a short amount of time through Excel and Microsoft Word mail merge. Companies send mail to consumers for a variety of reasons, including billing statements, advertisements or upcoming appointment reminders. You can consider making an address label using Excel when sending out a mass amount of mail at one time to many customers. Related: Basic Excel Formulas and How To Use Them When should you make an address label using Excel?

In this article, we explore when people use Excel to make address labels and how to do it. Using Excel to make them can save companies time when sending mail to a large number of customers. There are other capabilities you can use it for, including making address labels. Microsoft Excel is a program many industries use to input and calculate data.

Label wizard microsoft word 2007