How to Create Address Labels in Excel

Create your ow address labels for envelopes.

If you're having a special event, thinking about handwriting the addresses on each envelope certainly does sound like a drag. Instead of handwriting them yourself and risking the addresses to look a little sloppy, you can create address label right on Microsoft Excel. After you've created the address labels, all you have to do is print them out on white or clear labels and stick them right onto the envelopes.

Things You'll Need

• White or clear address labels

Instructions

1. Open Excel and set up a Data File. Set up about seven columns: last name, first name, title (if necessary), address, city, postal code, country (if necessary).

2. Type in the appropriate information into each column with all of the people that you want to address a letter or invitation to. Name and save the document, then close out of Excel.

3. Open Microsoft Office Word. Select "Mailings Tab > Start Mail Merge > Step by Step Mail Merge Wizard." Select "Labels" under Document Type, then click "Next: Starting document."

4. Select "Use an Existing List" under Recipients, then click "Browse." Select the Excel worksheet (from Step 1) from the Select Data Source dialog box, then click "Open."

5. Check the box next to each recipient you want to use in the Mail Merge Recipients dialog box. If you have a lot of labels you want to make, click on "Select All," then uncheck the boxes next to those you want to exclude. Select "OK > Next: Arrange your labels."

6. Click "Address Block." Select the address content that you want to include or exclude. For example, you may not want to include tittles if the envelopes are being sent to family and friends, rather than work associates. Click "OK."

7. Select each field whose font your want to change, if necessary. Select "Home tab > Font" to open the dialog box. Change the font and format of the labels as you wish.

8. Select "File > Save As" in Word. Name your labels and click "Save."

9. Select "Next: Preview Your Labels." Select Edit Recipient List" to make any changes, or "Next: Complete the Merge" to finish up.

10. Click "Edit Individual Labels." then select the items that you want to merge in the dialog box. Click "OK." You can edit and personalized any individual labels at this point, if necessary. Click "Save" when done.

11. Insert your white or clear labels into your printer. Select "File > Print" to print out all of your labels.

References

• Microsoft Suppot: How to Use Addresses From an Excel Worksheet to Create Labels in Word