helloandie

//From Salesforce documentation:
    public void sendEmail(String ToAddress) {
        // First, reserve email capacity for the current Apex transaction to ensure
        // that we won't exceed our daily email limits when sending email after
        // the current transaction is committed.
        Messaging.reserveSingleEmailCapacity(1);

        // Processes and actions involved in the Apex transaction occur next,
        // which conclude with sending a single email.

helloandie

Course Owner Query
SELECT Course_Owner__r.Name, Course_Owner__c.Compensation__c, Course_Owner__c.Compensation_Notes__c, Course_Owner__c.Compensated_As__c, RFS_Number__r.Name FROM Course_Owner__c WHERE Course__r.Name = 'G-4'

Course Director Query
SELECT Course_Director_Summary__c, Compensation_Summary__c, Compensated_As__c, RFS_Number__r.Name FROM Course_Director__c WHERE Course__r.Name = 'G-4'

Course Instructor Query
SELECT Instructor__r.Name, Instructor_Account__c, Compensation_Summary__c, RFS_Number__r.Name FROM Skill__c WHERE Course__r.Name = 'G-4'