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.