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'