#Mail merge from an excel spreadsheet how to#

If you have more than one sheet in the worksheet, all of them show up in the 'Select Table' box. Once you've located it, click on the file and click 'Open.'Īfter that, a 'Select Table' window appears.

In the search bar, type in the name of the Excel file. When the drop-down menu appears, select 'Use An Existing List.' Use the pop-up window to find your mailing list file. In the 'Mailings' tab in Word, click on the 'Select Recipients' option. The next step is to connect the addresses from Excel to the labels in Word. 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.

#Mail merge from an excel spreadsheet how to#

See your instant resume report on Indeed Get recommendations for your resume in minutes 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.