I have a database of users that I want to create a NewsLetter for. Here is my database
Here is my ColdFusion Code
<cfquery name="GetMembers" datasource="#REQUEST.dataSource#"> SELECT * FROM test </cfquery> <cfloop query="GetMembers"> <cfmail to= "#email_address#" from="firstname.lastname@example.org" 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 email@example.com. What could be going wrong?