Please send
comments/questions to
michael@
teratech.com

CFMAIL loop

•  Send one email for each record in the query 

<CFQUERY NAME="GetEmail"   DATASOURCE="Library">

   SELECT Email FROM Customer

</CFQUERY>

<CFMAIL QUERY="GetEmail"

      TO="#GetEmail.Email#"

      FROM="[email protected]"

      SUBJECT=“Test”

      SERVER="smtp.mycompany.com">

Hi There

   </CFMAIL>

Any records left? If so loop again

Start at first record

Previous slide

Next slide

Back to first slide

View graphic version