Adobe ColdFusion 8

Sending query-based e-mail

In the following example, a query (ProductRequests) retrieves a list of the customers who inquired about a product during the previous seven days. ColdFusion sends the list, with an appropriate header and footer, to the marketing department:

<cfmail
    query="ProductRequests"
    from="webmaster@MyCompany.com"
    to="marketing@MyCompany.com"
    subject="Widget status report">

Here is a list of people who have inquired about
MyCompany Widgets during the previous seven days:

<cfoutput>
#ProductRequests.FirstName# #ProductRequests.LastName# (#ProductRequests.Company#) - #ProductRequests.EMailAddress#&##013;
</cfoutput>

Regards,
The WebMaster
webmaster@MyCompany.com

</cfmail>

Reviewing the code

The following table describes the code:

Code

Description

<cfoutput> #ProductRequests.FirstName# ProductRequests.LastName# #ProductRequests.Company#) - ProductRequests.EMailAddress#&##013; </cfoutput>

Presents a dynamic list embedded within a normal message, repeating for each row in the ProductRequests query. Because the cfmail tag specifies a query, the cfoutput tag does not use a query attribute. The &##013; forces a carriage return between output records.