How to Create a Form to Print a Label

The computer has replaced the address book as the most efficient way of storing addresses. You can organize, manage and print addresses and address labels using Microsoft Word and Microsoft Excel. Use Microsoft Excel to create a form, or database, of your addresses; then use the Mail Merge feature in Microsoft Word to pull those addresses into a label template for printing. Creating an address form in Excel is easy and can be continually updated and edited.

Things You'll Need

• Microsoft Word
• Microsoft Excel

Instructions

1. Open a new worksheet in Microsoft Excel.

2. Create a separate column for each part of the address, and label each column's heading accordingly. Column headings should include last name, first name, title (if applicable), street address, city, state, zip code and country (if applicable).

3. Enter the addresses or paste them in from another source and save your address form.

4. Sort the addresses in Excel as desired. Typically addresses are sorted alphabetically by last name. The "Sort" dialog box is located in the "Data" menu.

5. Open the Mail Merge function in Microsoft Word when you are ready to print the labels. To access Mail Merge, click on the "Mailings" tab in Word 2007, or select "Letters and Mailings" from the "Tools" menu in Word 2003. Here you can start a new label document or open and add to an existing label document. Under "Select Recipients" click on " Use An Existing List." Locate and open the Excel address form in the "Select Data Source" box.

6. Continue to follow the Mail Merge prompts for selecting, importing, filtering and arranging the addresses for printing from Word.

Tips & Warnings

• If you have an electronic postage program, you can use this program in conjunction with Mail Merge.

References

• Microsoft Support: How to use addresses from an Excel worksheet to create labels in Word