I have two databases, one is a directory of people in the school, and the other is a list of notifications. Faculty, staff and students submit a notification when they get an award, grant, or some other cool professional thing happens to them.
I need to create a script that goes through the directory and sends an email to each person reminding them to use the notification form to submit their cool things. The email going to each person, is easy. Got that part. But I'm struggling with the body of the email. I want to include the five most recent notifications, and they need to be the Headline for the notification as a hot link. These are both fields, the headline and the URL of the published notification, but I'm not getting anywhere with combining these to form a hot link.
I can get a list of the URL's of the most recent five records, but can't a list of hot links where the headline is a clickable link.
I started to create a calculation field which creates the hot link, and was a bit hung up with escaping all of the html characters. But even if I get that sorted out, a list of these in the body of the email won't show as hot links unless the email is an HTML email, right?
Can I do this? Do I need a plugin to do it so that the email sent is an HTML email?
FWIW, this won't be to produce spam emails. Rather it will replace a current manual process where someone sends out these reminders every month. The users are already in the habit of receiving the reminders, amd it is a closed set of recipients.