Word Mail Merge: Labels

1. Tools [menu]
2. Letters and Mailings [pull-down menu]
3. Mail Merge [side menu]
4. Labels [radio button]
5. Next: Starting Document to go to Step 2 of 6 [arrow/link at bottom right]
6. Label Options [link at middle right]
7. Select label type [pop-up box]
8. OK [button]
9. Next: Select Recipients to go to Step 3 of 6 [arrow/link at bottom right]
10. Browse [link at middle right]
11. Navigate to the file with your merge data/records ... Excel, Word, Access, etc.
12. Select the file
13. Open [button]
14. If Access, select the table containing the data/records to import, Select All [button], OK [button]
15. If Word*, Select All [button], OK [button]
16. If Excel**, select the spreadsheet tab containing the data/records to import, Select All [button], OK [button]
17. Next: Arrange your Labels to go to Step 4 of 6
18. More Items [link at top right]
19. Select each field to insert on the label
20. Insert [button]
21. Close [button]
22. Repeat Steps 18-21 for each field
23. Update all labels [button]
24. Next: Preview your Labels to go to Step 5 of 6
25. If the labels have errors, click Previous [link] until you reach the item that is incorrect. Most likely to be Step 4 of 6 beginning with Step 18.
26. Next: Complete the Merge to go to Step 6 of 6
27. Print [link at middle right]
28. All [radio button]
29. OK [button]
30. Save the Merge Document -- but not necessarily the finished product.
     

*Word is easiest if the data is in a table with the first row containing a label for each column.
**Excel is easiest if the first row contains a label for each column.