When it comes to creating labels, Microsoft Office makes it relatively simple. If you have the data stored in another file, such as a spreadsheet, you can perform a mail merge to have the data imported into your labels. The steps below described how to create labels in Word using data that is stored in an Excel spreadsheet.

Before you begin using the Mail Merge wizard, you need to make a small configuration change within Word. From the Tools menu, click Options. Select the General tab and place a check beside the Confirm conversion at open option. With that step completed, you are ready to create your labels.

You can start the mail merge process in Word 2002 using the steps listed below:

  1. Open Word.
  2. From the Tools menu, point to Letters and Mailings, and click Mail Merge Wizard. If you are working in Word 2003, click Mail Merge.
  3. Under Select document type, click Labels. This option is used for creating address labels.
  4. Click Next: Starting document.
  5. Under Select starting document, select Change document layout.
  6. Click Label options. Select the paper type that you will be using such as Avery Standard 5160 Address. Click OK.
  7. Click Next: Select recipients.
  8. Under Select recipients, click Use an existing list. This option assumes that you are using address information stored in another file or database.
  9. Click Browse to locate your spreadsheet containing address information. Click Open.
  10. Select the table containing the address information and click OK.
  11. Place a check beside the recipients you want included in the mail merge. Click OK.
  12. Click Next: Arrange your labels.
  13. Click More items.
  14. From the Insert Merge Field dialog box, select the fields you want to include in the mail merge. Click Insert. These should be the fields that contain the recipients’ names and addresses. Close the Insert Merge Field dialog box.
  15. Format the first label as you want it to appear when it is printed. Click Update all labels.
  16. Click Next: Preview your labels.
  17. Click Next: Complete the merge.
  18. If you are satisfied with the appearance of the labels, click Print.

Your labels will now be printed. Each label should contain a different address based on the address information that was in your Excel file.

[tags]word,excel,diana huggins,150+ microsoft office tips,create label,mail merge wizard[/tags]