Friday, August 24, 2007

I want to print different sizes and styles of labels from YV

You can print lots of different labels if you know how to print labels from MS Word using a merge file. 
First use YV to create a report - pick the Family Directory (if you want parent name, address, phone) or Class/Mailing Label (if you want child name, address) or Class Name Tag (if you want child, class info). Use filters to select, for example, only Fall 07 Imagine That students. Then instead of printing, click on "CSV" which creates a CSV text file for you. 
Now in MS Word, you can use the label printing features (depends on version) to import this CSV file, select the style of label you want, and lay out the fields  exactly how you want them. Once it has been set up, you can just re-use it with different files for each class or semester etc.

If you have not created MS Word mail merge labels before, I am sure [fairly sure ;-) ] that the MS Word help documentation will make it easy for you...


Note for Kindermusik Young Child teachers: I have actually used this method to export a list of YC students for each unit (Class Name Labels) and created a template to print the appropriate information directly onto the labels that come in the materials packages - Now there's a time saver if you have a large YC enrollment!

2 comments:

Anonymous said...

What is the exact label I need to purchase to make the labels generated by the database print correctly?

Gerry C said...

The standard labels are Avery 5160 or similar. Letter size paper with 3 columns of 10 labels.
Be sure to use the PDF option, and don't let your pdf reader do any scaling when you print.
Mac users should print from Preview (not from Safari) unless you have installed the latest adobe reader plug-in for safari.

Gerry