I would like to create an automation script that will send a customized spreadsheet of students assigned to a particular school, to that particular school’s assigned staff person.
I’ve used Debbie’s sample of an automation file to send a customized form letter based on values in an underlying query before and it worked well. But now I would like for each customized form letter to have an attachment that lists only the associated student.
My question is can I use the school_var I create in a set_variable activity in a SQL statement? To do so can I use the find & replace activity on a .sql file?