Denville Striders Label Printing Process

 

Place the files GenericTrackLabels.doc and InputForGenericTrackLabels.xls on your computer in the My Documents directory.  Modify the InputForGenericTrackLabels.xls so that it contains all the information about the current athletes.  Remove any athletes that have left the program.  It should contain the following information for each athlete.  Sort the xls file, InputForGenericTrackLabels.xls by last name and save.

 

First Name

Last Name

Age

Gender

 

Double Click on the file à GenericTrackLabels.doc

 

It will open in Microsoft Word for Windows

 

If a dialog box appears asking to continue                                                      Select YES.

 

If a dialog box appears asking to connect to Access data                            Select OK

 

If a dialog box appears telling you have an error                                            Select OK

 

If a dialog box appears asking for a data source select Find Data Source

 

Go to your computers C drive and locate the file à InputForGenericTrackLabels.xls

 

Select the file                                                                                                        Select OPEN

 

If you are asked to Select a Table then                                                            Select Sheet1$      Select OK

 

The labels should be visible in Microsoft WORD

 

In Microsoft WORD go to the toolbar and select

 

Tools

Letters and Mailings

Mail Merge...

 

A Mail Merge side bar should appear on the right side of the document.

 

Select the Blue Link near the bottom.                                               Next: Arrange your labels

 

Select the Blue Link near the bottom.                                               Next: Preview you labels

 

Select the Blue Link near the bottom.                                               Next: Complete the merge

 

Select the Blue Link near the top.                                                      Print...

 

A dialog box will appear that will ask you if you wish to Merge to Printer                Select OK

 

A dialog box will appear that will ask you if you wish to Print                                     Select OK

 

Load your labels into your printer FACE UP.

 

You will need to hit the button on your printer to manually feed the pages.