how do I send out emails only if the row in column area is equal to test?

If I have a query result in cold fusion, how do I send out emails only if the row in column area is equal to test?

What I'm looking for is the code to loop through the query and send out emails like this:

<cfmail type="html" to="niko@test.co.uk"

server="#Application.MailServer#" port="25" timeout="120">#body#</cfmail>