I would like to send a personalized email to several email addresses, and display information pulled from each individuals record. I would like the email to read something like the following, bracketed information is what I would like to have pulled from each record:
"Thank you for registering [Childs First Name] for [Resident Camp]! Your balance due is: [Balance Due]. Please submit final payments at least two weeks prior to the start of camp. I will list the forms we have received and the forms that are still needed below. Please find the forms in the attachment."
Forms Received or Needed: