CFMail Example

It should be pretty simple to use a query to specify which members you want to receive an email.

Here is an example adapted from: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-pta.htm

<cfmail
    query="QUERYNAME"
    to = "#QUERYNAME.EmailAdd#"
    from = "#form.mailFrom#"
    subject = "#form.subject#">
    Dear #QUERYNAME.Full_Name#,
    This message was sent by an automatic mailer built with cfmail:
    = = = = = = = = = = = = = = = = = = = = = = = = = = =
    #form.body#
</cfmail>

Once you get to this point the most important thing to remember is to check your query results very CAREFULLY to make sure that you are only sending out emails to the people you want to receive them.