Send email from a text field that includes variables
I am trying to figure how to send an email from a text field that merges data from multiple records.
1. Text field I use to send emails to students
2. Popup menu that enters variables from other fields such as first name, last name etc.
What I would like to do is to be able to write something like in the text box:
You are student number (student#) and your lesson is on (lessonday) at (lessontime).
The paretheses would reference fields and be chosen from the popup menu. The idea would be for this to work across multiple records. So far, I have the popup menu set up to send text to the text field. Not sure on the coding...
Is this possible? I am stuck.