Using Mail Merge to Create Labels from the Excel Open/Close Report

Quick Reference

1. In Microsoft Word, click Tools, Letters and Mailings, Mail Merge
2. Click Labels.
3. Click "Next: Starting Document".
4. Click Labels Options.
5. Choose the Labels you use (i.e. Avery 5660) and click OK.
6. Click "Next: Select Recipients" at the bottom of the Task Pane.
7. Find the Excel spreadsheet.
8. Click the checkboxes on the left to select classes from which to create labels and click OK.
9. Click Next: Arrange your labels.
10. Type and format text that you want to appear on all labels.
11. Click More Items from the Task Pane.
12. Insert fields.
13. Click Update all labels.
14. Click Next: Preview your labels.
15. Click Next: Complete the merge.
16. Click Print.