Using Mail Merge for Labels in Word 2003

1. Open Word and go to Tool>Letter and Mailing> Mail Merge.

2. Select Labels.

3. Select Change document layout.

4. Select 5160 under Product number. The press OK.

 

5. Click on "Next: Select recipients"

6. Click Browse...

7. Select the excel sheet that contains the information you want to import. Then press open.

8. Press OK.

9. If you want to exclude a line remove the check park next to in. Then press OK.

10. Go to Tools>Letters and Mailing>Show Mail Merge Toolbar

11. Select Insert Merge Fields.

12. Select the information you want on the labels and then press Insert. Do this for each piece of information you would like on the labels.

13. If you want to put the information on multiple lines, format the information tags accordingly.

14. Click Next: Arrange your labels.

15. Click Update all labels.

16. Click Next: Preview your labels.

17. Click Next: Complete the merge.

18. Click Edit individual labels...

19. Select all and click OK.

---