After running a query statement, the LABELS button can be selected to create different types of labels, such as mailing labels, student folder labels, etc. Listed below is an example of a Query to print address labels to the parents of Gate students.


To create address labels or any label containing more than one line, the \ must be used in the query statement.  This will force the query to drop down a line when printing the labels.  


To have a text expression print, double-quotes must be placed around it. For example,  “To the Parents/Guardians of: ”




The following is the definition for the query above:


LIST                                          = display on the screen
STU                                          = using the student data table
“To the Parent/Guardian of:” = creates a text statement
\                                                = drops down to the next line
NM                                            = creates students full name from the LN and FN in STU table
                                               = drops down to the next line
AD                                            = students address from the STU table
                                               = drops down to the next line
CY                                            = students city from the STU table
ST                                            = students state from the STU table
ZC                                            = students zip code from the STU table
IF U6 = G                                 = only select if the U6 field contains a G for GATE students 

                                                   (this field is only an example for GATE)


To create the query, click on the RUN button. The following results will display.  The text expression and the ‘\’ entered create their own field for each student record.  The ‘\’ field is read by query and forces the program to drop down a line when printing.




After the query statement has been generated, click on the LABELS button and the following selection box will display. In Aeries Web a report is generated to create the labels onto Avery 5160 labels. To properly print out the labels we suggest creating a PDF of the labels and setting the “Print Scaling” option to “None”. 

 



The following QUERY Labels will display. Verify the label data is correct and will fit on the label selected.  To print the labels, click on the Printer icon at the top of the screen.





Customizing Labels


Aeries Client allows you to customize the labels by clicking on Custom Labels and selecting OK.  Please note that Barcodes cannot be printed on a custom label.   




The following form will display.  This form will allow you to create custom label templates that can be Saved.  Default templates for Avery labels can also be loaded by clicking the Load Default Templates button. Once loaded the drop down will display all available templates.




To create a new template from a saved template, select a template from the drop down and enter the label format. For example, the Avery 5160 default template was selected from the drop down.  The Font Size was changed to 10 and Font Weight to Bold. 




Click on the Save Template button and the following message will display.  Enter the name of the new template which MUST be different than one in the drop down listing.  Click on the OK button and a message will display indicating that it was saved.

 



After the template is saved it will display in the drop down.  To print these labels select the template and click on the OK button. 




The Labels will be generated with the template selected.  For example, this is an Avery 5160 that now has 10 Font and is Bold. 




To create a new template with no defaults from another label click on the New Template button. Notice that the defaults changed.  Enter ALL sizes into the fields displayed and click on the Save Template button.  A message will display to enter the name of the Template. After entering the name of the template click on the OK button and the template will now display in the drop down.




NOTE:  Remember to always print out one page on regular paper and compare it to the labels to ensure it formatted properly.



To delete a Saved Template click on the drop down and select the template.  Click on the Delete Template button and a message will display confirming the deletion. Click on the OK button and the template will no longer display in the drop down.