SendMail script with multiple fields
Hey, everybody. Yet another novice question. I'm trying to put together a script that sends out an e-mail. In the message of the email, I want to be able to use multiple fields from the DB, but am having trouble with the code. For example, I want to say, "Contact Management::Name_First, This is just a reminder of your appointment on Contact Management::Assessment_1_Date," and so on. Any ideas?
Also, is there a way that I can trigger this script to run on a particular day that's based on the date of a particular field?
Thanks, in advance, for all of you guys' help.