Hi Scott, Try this out:
<cfloop query="qname"> <cfif qname.pswd_exp - CreateODBCDate(now()) lte 10> <cfmail to="#send_to_e-mail_address#" from="[EMAIL PROTECTED]" subject="Password Exp Alert" server="server identifier" username="server username" password="server password"> <cfmailpart type="text"> <--- text version e-mail Your password will expire on #DateFormat(pswd_exp,"m/d/yy")# </cfmailpart> <cfmailpart type="html"> <--- html version e-mail <p>Your password will expire on #DateFormat(pswd_exp,"m/d/yy")#</p> </cfmailpart> </cfmail> </cfif> </cfloop> This will loop through the query checking expiration dates against the current date. If there is a result and e-mail will be sent out to the e-mail address in the database. If no results are found, nothing happens. Also note, the two cfmailpart(s). This allows you to send out both a text based e-mail and html e-mail at the same time. If the receiver's e-mail program can only read text based e-mails, then they will see your text based version if they can do html, then they will see that version. "" Do not use any html code inside the text version "" When using cfmailparts like this, the text version (simplest) form of e-mail must always be first in the process. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3138 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
