How to Create Labels in Microsoft Office 2007 From Excel 2007

1. Open a new Excel spreadsheet. Type 'Last Name' into Cell A1. Move right across the first row of cells labeling each new cell with the information you need in order, such as 'First Name,' 'Title,' 'Address,' 'City' and 'Zip Code.'
2. Type in the relevant information for each mailing label you need on the column below the row heading. For example, type in the last name for each contact underneath the 'Last Name' column.
3. Highlight the entire section of columns and rows with the mailing label information, including the top row headers. Navigate to the 'Formulas' tab and click 'Define Name.' Type in a name for the address list, such as 'Invitations' or 'Mailing List.'
4. Save the spreadsheet and close the Excel 2007 program. Open a new Word 2007 document. Navigate to the 'Mailings' tab and click 'Start Mail Merge.' Select 'Labels.'
5. Use the drop-down menus to select the specific type of labels you are using. Check the code on the back of the label's packaging if you aren't sure what type you have.
6. Click 'OK' and then click the Microsoft Office button at the upper-left end of the window. Select 'Word Options.' Choose 'Advanced' and then click the check box labeled 'Confirm file format conversion on open.'
7. Click 'OK.' Navigate back to the 'Mailings' tab and click 'Select Recipients.' Choose 'Use Existing List.' Click the name of the Excel spreadsheet you saved earlier and choose 'OK.'
8. Click 'Match Fields.' Use the drop-down menus to match the headers you created in the Excel spreadsheet with the various fields that will appear on the mailing label, such as 'First Name' and 'Last Name.'
9. Select 'Preview Results' to ensure the mailing labels look correct. Click the 'Finish Merge' link and then select 'Print Documents' to print the labels.