• Home
• Tutorials
• Forums
• Reference
• Developers
• Advertise
• About Us

Auto Event Emailer

<CFSET today = "#DateFormat(now(),'mm/dd/yyyy')#">

<cfquery name="change"
             datasource="[yourDSN]"
             dbtype="ODBC">

        SELECT  * 
        FROM     change
        WHERE   impdate is '#today#'

</cfquery>


<cfloop query="mailing">

   <CFMAIL
            to="whoever@youwant.com"
            from="valid@from-address.com"
            Subject="Important">

   Message here regarding today's important event.

   </CFMAIL>

</cfloop>

This code saved my butt on several occasions. I had a db with different events happening that were entered by several other people in different locations. Part of more code updated a calendar program, but this little bit sent an email directly to whoever (me) early in the morning of the event.

This code was triggered every day at 1am by CFschedule. All that does is hit the page and execute it, the code on the page did the rest. First thing I did was set today's date format in the same manner it was entered into the database. Then I queried the db for any row with the field "impdate" the same as today's date. If there are none, it simply does nothing. If there are any, it sends out a preformatted email, or even a db driven email that tells what the event is and when it will happen.

So each morning I knew what was going to happen as soon as I read email. You could even have it go to your mobile phone if you have email capabilities.