-
Step 1
Type a header over each of the columns of information. For example, type "Name" over the list of names, "Street Address" over the list of addresses, and "City," "State" and "Zip" over each of their respective columns. You can add extra columns for headings like Mr. and Mrs. Save the file; remember its name and where you filed it.
-
Step 2
Open Microsoft Word and access the Tools menu. You will see the "Letters and Mailing" option. Click on "Mail Merge Wizard." You will need to pick what kind of label you want to print. Typically, this corresponds to a number found on the packaging of the labels. You will then be prompted to select the data file. Choose an existing file and click on the address file you previously saved in Excel. Determine if the box that mentions if your first row contains headers is checked, then hit "OK."
-
Step 3
Follow the Wizard through the rest of the process. It will initially include everyone on your list, but you will later have the option of deleting some under the "Edit Recipients List" command. Preview your work; make sure the spelling is correct, as well as the spacing within the address labels. You can go back and make corrections in Word, but you cannot open the Excel file while you are in the Mail Merge Wizard.
-
Step 4
Print your labels on a plain piece of paper, to review your work and to prevent wasting a sheet of labels. Proof the addresses, making sure the print size is right, the spelling is correct and the layout is mail-ready. Print the labels on the chosen label sheets. You will be prompted to save the file; you can choose to save the address-label file or to delete if it is not something you will use again. Your original Excel spreadsheet will remain intact, and can be accessed again later for another mail merge.
Bulk mailing
