Dynamic Content in Email
I work at a college and we had the idea to send our applicants a monthly check-in email showing the steps they have completed as well as the steps they still need to take to become students. For example, something like this:
As of 7/13/16, this is the information we have on file for you:
- Applied for Admission
- Sent us transcripts
These are the items you still need to complete to become a student:
- Send us ACT/SAT scores
- Complete testing
- File FAFSA
There are five steps to take, resulting in 31 possible combinations. I'd really hate to have to set up 31 different emails and was wondering if there was a way to have the "steps" content generating automatically. For instance, if I upload a list of applicants with a column for each of these steps marked true or false, is there a way I could assign rules such as, If "Applied for Admission" is "TRUE" display "Applied for Admission" in the place I designate?