Email Active Students

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.

 

If you need to send an email blast to a list of active students, use the example query below. You an also use this query as a basis for emailing active academic staff, support staff, or all staff members.

SELECT a.uname,a.email,a.lname,a.fname,a.personID
FROM person a
LEFT JOIN student b ON a.personID = b.stuID
WHERE b.status = 'A';

 

Last Modified: May 25, 2015 @ 10:10 PM

Was this article helpful?

Related Articles