- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
<!----- 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 --->
|URGENT: Web Server Configuration Tool not working after ColdFusion 11 license update||10||356|
|Cftransaction doesn't seem to be working quite right. Still deleting a record when purposely testing a error in the mix.||14||60|
|need help with one more outer join sql query in coldfusion||4||33|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!