90 likes | 211 Vues
This guide provides detailed instructions for creating and printing two sets of graduation labels for seniors using Skyward Data Mining and Microsoft Word. Step by step, we outline how to export names to Excel, format the list, and set up mail merge in Word. The process includes editing the labels, choosing font settings, and ensuring proper layout for printing. Perfect for administrators or teachers preparing for graduation ceremonies, this comprehensive resource ensures no detail is overlooked, from gathering names to final printing.
E N D
Senior Labelsfor Graduation One set First/Middle/Last Name Two sets Full Name Last, First Middle April 29, 2009
First/Middle/Last Name Order(print one set) • In Skyward Data Mining • SLL Senior List First Last Name • Run to EXCEL • Use template field lengths • Delete Header • Delete grade level column • Save as V: Senior List First Last • Close Data Mining
First/Middle/Last Name LabelOpen In WORD • Open WORD • Tools • Letters and Mailings • Mail Merge • Choose Labels • Next: Starting document • Label Options – 5160 Address – click OK • Next: Select recipients • Browse • My computer Local C: senior labels first last • Click OK • Click OK on list • Next: Arrange your labels • Continue on next slide
First/Middle/Last Name LabelContinued In WORD • Click on More items… • Highlight First name click insert, close then space bar • More items… • Highlight Middle name click insert, close then space bar • More items… • Highlight Last name click insert then close • Update all labels • Next: Preview your letters • Next: Complete the merge • Edit individual labels… • Click OK • Save
First/Middle/Last Name LabelContinued In WORD • Edit - Select All • Change font to 14 • Click Bold • Save • Print one set of labels
Last, First Middle Full Name Order(print two sets) • In Skyward Data Mining • SLL Senior List Last First Name • Run to EXCEL • Use template field lengths • Delete Header • Delete grade level column • Save as V: Senior List Last First • Close Data Mining
Last, First Middle Name LabelOpen In WORD • Open WORD • Tools • Letters and Mailings • Mail Merge • Choose Labels • Next: Starting document • Label Options – 5160 Address – click OK • Next: Select recipients • Browse • My computer Local C: senior labels first last • Click OK • Click OK on list • Next: Arrange your labels • Continue on next slide
Last, First Middle Name LabelContinued In WORD • Click on More items… • Highlight name, click insert then close • Update all labels • Next: Preview your letters • Next: Complete the merge • Edit individual labels… • Click OK • Save
Last, First Middle Name LabelContinued In WORD • Edit - Select All • Change font to 14 • Click Bold • Save • Print two sets of labels