I have a database of users that I want to create a NewsLetter for. Here is my database

DB

Here is my ColdFusion Code


<cfquery name="GetMembers" datasource="#REQUEST.dataSource#">

  SELECT *

  FROM test

</cfquery>

<cfloop query="GetMembers">

  <cfmail

  	to= "#email_address#"

    from="johnbarr@hawaii.edu"

    subject="Testing"

    type="HTML">



	 <html>

	   <head>



	   </head>

	   <body>

	     Testing cfmail

	 </html>

  </cfmail>

</cfloop>

<cfoutput>

your mail was send to: <br />

    <cfloop query="GetMembers">

	#GetMembers.email_address#,<br />

  </cfloop>

</cfoutput>

In the output it says that it was send, but I only get the first one to johnbarr@hawaii.edu. What could be going wrong?

By |2009-04-12T02:46:09+00:00April 12th, 2009|