To download an excel
spreadsheet of all secondary schools in the Eastern District (according
to NCDPI), click HERE.
(Note: Be sure to download it to
a location you will be able to find later -- we suggest your "My
Documents" folder.)
If you would like to
print mailing labels from this spreadsheet, follow the instructions
below, or you can download and print these instructions HERE.
(Note: this is Word Document
which is 18 pages long and contains many large graphics which may
use up a considerable amount of color ink! You may want to change
your print settings to "Draft" or "Black and White"
to save ink.) |
| |
How
to Print Labels from the Eastern District Spreadsheet |
| 1. Save the spreadsheet
in a location you will remember – the default location for saving
is usually the “My Documents” folder.
2. Exit Excel and Open Microsoft Word.
3.
On the Tools Menu, point to “Letters and Mailings”
and then to “Mail Merge”.
|
|
| |
| 4. On the following
screen, click on “Labels”, and then on
“Next: Starting Document”. |
|
| |
| 5. Click on “Label
Options” to specify the type of labels you are using. |
|
| |
| 6. From the “Product
Number” menu, choose the type of labels. In this example,
I used 5160 because Avery 5160 is one of the most common mailing labels
used. |
|
| |
| 7. Once you have
chosen your labels, click “Next: Select recipients”. |
|
| |
| 8. Click on “Use
an existing list” – then click “Browse”.
|
|
| |
| 9. Find the Excel
spreadsheet that you downloaded from the website. It should be named
“easternsecondaryschoollisting”. |
|
| |
| 10. In the “Select
Table” screen, click “OK”. |
|
| |
| 11. To be sure
that all the schools are printed, you can either check the box beside
each, or click “Select All” at the bottom
of the window. Note: You may also sort the spreadsheet
by county, school, LEA, etc. in this window. |
|
| |
| 12. After you
select your recipient list, click “Next: Arrange your
labels”. |
|
| |
| 13. Click on
“Address block…” |
|
| |
| 14. At the bottom
of the pop-up window, click “Match Fields”
to match the field labels of the Eastern District spreadsheet with
the fields in the mail merge label. |
|
| |
| 15. Match the
fields in “Required Information” to the
fields in the Eastern District spreadsheet by clicking the drop-down
menu (where it says “not matched”). |
|
| |
| 16. For these
labels, I matched “Principal” with “Last
Name”. Once you have matched fields, click “OK”.
Note: With the Eastern District Spreadsheet,
the Principal’s name is all in one field, so you’ll only
need to match Last Name with Principal. If you match First and Last
Name in the window below to Principal, you’ll end up with the
principal’s name on each label TWICE. Also, when matching
the address fields, make sure you choose “Mailing Address”,
not “Physical Address” from the Eastern District Spreadsheet. |
|
| |
| 17. Now click
“Update all labels”. |
|
| |
| 18. After you
click “Update all labels”, click “Next:
Preview your labels”. Note: You
may have to click on a down arrow underneath the “Update all
labels” button to see the “Next: Preview your labels”
link. |
|
| |
| 19. Click “Next:
Complete the merge.” Note: When
previewing labels, it only shows one sheet of labels, but when you
print, it should print them all. |
|
| |
| 20. Click “Print”. |
|
| |
| 21. This should
complete the merge and print the labels. You can save these labels
just like you would save any other Word Document! |
