Mail Merge

Are you new to the eduTrac SIS online user's manual? If so, click here for a starting point. If you are looking for technical documentation, then check out the Wiki.

 

The mail merge feature allows you to use a saved query to generate mailing labels using Avery templates. In order to create a saved query, your fields must be listed in the following order (fname,lname,address1,address2,city,state,zip).

So, let’s say you wanted to¬†generate mailing labels for prospective students who have just been accepted to your institution. Your saved query would look something like the following example:

SELECT a.lname,a.fname,c.address1,c.address2,c.city,c.state,c.zip
FROM person a
LEFT JOIN application b ON a.personID = b.personID
LEFT JOIN address c ON a.personID = c.personID
WHERE b.applStatus = 'Accepted'
AND b.applDate BETWEEN '2012-07-02' AND '2012-09-01'

 

Last Modified: Dec 24, 2015 @ 4:35 PM

Was this article helpful?

Related Articles

You must be logged in to reply to this topic.