User Guide
Sample Uses of cfmail 305
#ProductRequests.FirstName# #ProductRequests.LastName#
(#ProductRequests.Company#) -
#ProductRequests.EMailAddress#&##013;
</cfoutput>
Regards,
The WebMaster
webmaster@MyCompany.com
</cfmail>
Note the use of the cfoutput tag to present a dynamic list embedded within a
normal
cfmail message. The text within the cfoutput is repeated for each row in the
ProductRequests query, while the text above and below it serve as the header and
footer, respectively, for the mail message. The &##013; in the cfoutput block forces a
carriage return between output records.
Sending e-mail to multiple recipients
In the following example, a query (BetaTesters) retrieves a list of people who are beta
testing ColdFusion. This query is then used to send a notification to each of these
testers that a new version of the beta release is available:
<cfmail query="BetaTesters"
from="beta@MyCompany.com"
to="#TesterEMail#"
subject="Widget Beta Four Available">
To all Widget beta testers:
Widget Beta Four is now available
for downloading from the MyCompany site.
The URL for the download is:
http://beta.mycompany.com
Regards,
Widget Technical Support
beta@MyCompany.com
</cfmail>
Note that in this example, the contents of the cfmail tag body are not dynamic, that
is, the tag does not use any # delimited dynamic parameters. What is dynamic is the
list of e-mail addresses to which the message is sent. Note the use of the TesterEMail
column from the BetaTesters query in the
to attribute.