Request the Open/Close Report in Excel format from the Database Administrator if necessary. The Database Administrator will email the report to you.
Save the attached Excel spreadsheet to the My Data Sources folder in the My Documents folder or somewhere else where you can find it.
Open Microsoft Word.
Click Tools, Letters and Mailings, Mail Merge
The Mail Merge Task Pane will open to the right of your document.
Click the button next to Labels.
Click "Next: Starting Document" at the bottom of the Task Pane.
Click Labels Options.
Choose the Labels you use (i.e. Avery 5660) and click OK.
Click "Next: Select Recipients" at the bottom of the Task Pane.
Click "Browse"
In the Select Data Source window, find the Excel spreadsheet, click to highlight it, and click Open
In the Select Table window click OK.
Click "Clear All"
Click the checkboxes on the left to select classes from which to create labels.
Advanced Tip: You can double click the blue title bar where it says Mail Merge Recipients to enlarge the window.
Advanced Tip: You can limit the visible records by clicking the arrow at the top of the column. In this example clicking the arrow next to Term and then clicking A limits the records to the A term.
Advanced Tip: You can alphabetize any column by clicking on the text of the column title. Click again to reverse the order.
Once you have checked the boxes for all classes you want to use click OK.
Click Next: Arrange your labels from the bottom of the Mail Merge Task Pane.
Type and format text that you want to appear on all labels.
Click More Items from the Task Pane.
Click the field from the spreadsheet you want to appear on the label and click Insert.
Click Close.
Repeat clicking More items, selecting fields, inserting, and closing to complete your label.
Click Update all labels.
Click Next: Preview your labels.
Click Next: Complete the merge.
Click Print.
Advanced Tip: Click Edit individual labels to make modifications.
