Browse » Home
Tuesday, April 24, 2012
How to Make Mailing Labels in Excel 2007
1. 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.
2. 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.
3. 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.
4. 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.'
5. 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.
6. 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.