With your address list set up in an Excel spreadsheet, use mail merge in Word to create mailing labels.

  1. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.

  2. Choose Labels > Next: Starting document.

  3. Select Label options, choose your Label vendor and Product number (find this on your label package), and then select OK.

  4. Select Next: Select recipients > Browse

  5. Double-click your Excel address list, and then select OK.

  6. Select Next: Arrange your labels.

  7. Choose Address block, select OK, and then select Update all labels.

  8. Select Next: Preview your labels, and then Next: Complete the merge.

  9. Select Print > OK, choose a printer, and then select OK


Source: Microsoft