Enter your contact information into a Microsoft Excel 2007 spreadsheet or an Access 2007 database. These two programs are designed for storing large amounts of form data you will need for your labels. For example, if you're sending a mailing to friends, enter a name, street address, city, state, and zip code for each member of the list on each row of the spreadsheet or database.
Save your Excel spreadsheet or Access database document, then close the program. Load Microsoft Word 2007.
Click "Mailings" then "Start Mail Merge" to begin the process of mailing your contact information with your label template. Select "Labels" from the drop-down list.
Choose the label size for your sheet of labels from the list of options (you can find the exact size on the package for your label paper).
Click "Select Recipients" from the "Mailings" toolbar, then open "Use Existing List..." Search for the Excel or Access file you saved in Step 2, and click "Open."
Click inside the first label box and select "Insert Merge Field" on the Word main menu. Insert each field (such as name, street address, and city in the example) exactly as you want it to appear on the sheet of labels. You'll see the words "Next Record" in each subsequent label box. This means the mail merge wizard will automatically fill in the rest of the labels before printing.
Select "Finish & Merge" on the Word main menu and choose "Print Documents" to print your labels. You can also select "Edit Individual Documents" if you want to review the labels before printing .