How to Make Mailing Labels in Excel 2007
Microsoft Excel 2007 is a popular spreadsheet application used for creating lists and storing data. If you have a list of names and addresses saved in an Excel workbook, you can use it as the data source to create and print mailing labels from Microsoft Word using the "mail merge" feature. This will save you the time and trouble of typing the information directly into Word.
Things You'll Need
- Excel 2007
- Word 2007
- Printer label pages
Open the Excel 2007 worksheet containing the list you want to use to make mailing labels. If you do not yet have a list, open a blank worksheet. Enter a name for each column in the first row of the worksheet. Choose names that will be easy to understand in the merge, such as "First Name," "Last Name" and "Street Address." Save and close the worksheet.
Start Word 2007. Go to the "Mailings" tab and click "Start Mail Merge." Select "Labels" from the drop-down list. The "Label Options" dialog box opens.
Select the label settings for the label pages you are using. Pick the label brand name from the "Label Vendor" drop-down list. Select the product number that is listed on the label package in the "Product Number" list. Click "Detail" to view the details for a label, such as the size and the number of labels per page. If the label you are using is not listed, click "New Label" and enter the specifications for your label. Click "OK" when you have made your selections.
Click "Select Recipients" in the "Start Mail Merge" section of the "Mailings" tab. Click "Use Existing List." Navigate to the Excel 2007 worksheet containing the list you want to use to make mailing labels. In the "Select Table" dialog box, click the sheet of the workbook that has the list you want to use. Click "OK."
Click "Address Block" in the "Write & Insert Fields" group of the "Mailings" tab. Click the "Match Fields" button. Match the address block fields to the field names you used in your Excel worksheet. Click "OK" to close the "Match Fields" dialog box. Click "OK" to close the "Insert Address Block" dialog box.
Click "Update Labels" in the "Write & Insert Fields" group of the "Mailings" tab. Click "Finish and Merge" in the "Finish" group of the "Mailings" tab. Select "Edit Individual Documents" to create a new document with the merged mailing labels and print them later or click "Print Documents" to print the labels immediately.