Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
<!----- Name: email_principals_template.cfm Author: Eric B Description: This template does these actions: 1) query table NBPTS_Principals_Unapproved to get Names and Email addresses of 914 Principals who were not approved for the NBPTS Field Test 2) create an HTML formatted email message to send to each principal 3) Created: September 2010 ColdFusion Version 8 MS SQL Server 2005 -----> <!--- Set the datasource ---> <cfset ds="ebwebwork"> <!--- select columns from table tbl_NBPTS_Principals, for use later in this application ---> <cfquery datasource="#ds#" name="GetPrincipalstoApprove"> SELECT UserID , Salutation , FirstName , LastName , Address , City , State , ZIP , UserEmail FROM NBPTS_Principals_Unapproved </cfquery> <cfloop query="GetPrincipalstoApprove"> <!--- generate email ---> <!--- email message goes inside CFLOOP ---> <cfmail SERVER="mail.nbptsprincipals.org" FROM="NBPTS Principals Field Test" TO="#UserEmail#" SUBJECT="NBPTS Principals Field Test" username = "xxxxxxxx" password = "xxxxxxxx" type="html" SpoolEnable="Yes" query="GetPrincipalstoApprove" maxrows="10"> <!--- begin cfoutput ---> <cfoutput> <!--- begin formatted email message ---> <html> <head> <title>NBPTS Principal Field Test</title> </head> <body lang="EN-US"> <div style="width:800px;padding:20px;text-align:left;"> <img src="http://www.nbptsprincipals.org/img/nbpts_email_letterhead.gif" width="710" height="158" alt="NBPTS Letterhead" /> <p>September 17, 2010</p> <p>#GetPrincipalstoApprove.Salutation# #GetPrincipalstoApprove.FirstName# #GetPrincipalstoApprove.LastName#<br /> #GetPrincipalstoApprove.Address#<br /> #GetPrincipalstoApprove.City#, #GetPrincipalstoApprove.State# #GetPrincipalstoApprove.ZIP#</p> <p>Dear #GetPrincipalstoApprove.Salutation# #GetPrincipalstoApprove.LastName#,</p> <p>Thank you for expressing your interest in participating in the National Board for Professional Teaching Standards Principal Certification field test. We had an overwhelming response from principals across the country, hearing from nearly 2,000 principals who indicated a desire to take on this professional challenge.</p> <p>We only selected 600 principals based on field test criteria. According to these criteria, you were not selected to participate in the field test. Selection to participate in the field test is not a designation of merit, but rather designed to assure validity and reliability of the assessment for principal in all school types.</p> </div> </body> </html> </cfoutput> <!--- close cfoutput ---> </cfmail> <!--- close cfmail ---> </cfloop> <!--- close cfloop --->
Join the community of 500,000 technology professionals and ask your questions.