Here is the complete code for the cfmail:
[code]
<cfmail.....>
<cfquery name="getReg" datasource="seligins">
SELECT b.firstname, b.lastname, a.course_date, a.course_name
FROM tblCourse a, tblAttendee b, tblRegistration_details d
WHERE a.course_id = d.course_id
AND d.h_email =...