Creating and Printing Labels with Mail Merge

You can use the same data source that you created for your letters for your labels!
  1. Open a blank document.
  2. Click on the dropdown arrow in the upper right-hand corner of the Task Pane.
  3. Select the option Mail Merge.
  4. The Select Document Type pane will appear.
  5. In the Select Document Type section, choose the Lables option.

  6. Click on the Step 1 of 6 - Next: Starting Document link at the bottom of the Task Pane.
  7. The Select Starting Document Mail Merge pane will appear.
  8. Click on the Label Options link in the middle of the task pane.

  9. The Label Options dialog will appear.

  10. Choose the desired label type.
  11. Click on the OK button.
  12. You will return to your blank document, which will now display blank labels.
  13. Click on the Step 2 of 6 – Next: Select Recipients link at the bottom of the Task Pane.
  14. The Select Recipients pane will appear.
  15. Click on the Browse link in the Use an Existing List section.

  16. The Select Data Source dialog will appear.

  17. Browse to and select your data source.
  18. Click on the Open button.
  19. The Mail Merge Recipients dialog will appear.

  20. You can edit and sort your entries from this dialog.
  21. When you have finished editing and sorting, click on the OK button.
  22. Click on the Step 3 of 6 - Next: Arrange Your Labels link at the bottom of the Task Pane.
  23. The Arrange Your Labels Task Pane will appear.

  24. Place your cursor in the top left label.
  25. Click on the More Items link in the middle of the Task Pane.
  26. The Insert Merge Field dialog will appear.

  27. Click once on the desired data field.
  28. Click on the Insert button.
  29. The data field will be inserted into the top left label.
  30. Click on the Close button.
  31. Repeat the field insertion process to insert the remaining data fields into the label.
  32. When you have completed the label, click on the Update All Labels button in the middle of the Task Pane.
  33. The fields and formatting of the top left label will be copied into all of the remaining blank labels.
  34. Save your label template in the same directory as you saved the letter and data source.
  35. Click on the Step 4 of 6 - Next: Preview Your Labels link at the bottom of the Task Pane.
  36. The Preview Your Labels Task Pane will appear, along with your newly merged labels.

  37. Using the buttons to the right and left of the Recipient field, scroll through the results to check your labels for any necessary edits.
  38. You can also edit your data, search for recipients, and/or exclude recipients at this stage.
  39. When you are satisfied with the results, click on the Step 5 of 6 - Next: Complete the Merge link at the bottom of the Task Pane.
  40. The Complete the Merge Task Pane will appear.

  41. Edit or print your labels!

Click HERE to return to the Table of Contents.