Hi all,
I am having a problem getting email results from a query. I need to send a
report of subscribers to a magazine. For security reasons I want to send one
email per query. Originally, without a loop, if the query yielded six
records six separate emails were sent. This is not acceptable. So I added a
loop. Now all six records are in one email -- six times! What am I missing?
Help!!
Here's the code I have so far:
<CFMAIL QUERY="abenakireport"
TO="[EMAIL PROTECTED]"
FROM="[EMAIL PROTECTED]"
SUBJECT="Abenaki report"
SERVER="mail.marksport.com">
Here is a list of subscribers requesting a free copy of Saltwater Fly Fishing.
Requests were made between #FORM.startdate# and #FORM.enddate#.
Name
Address
Phone number
<CFLOOP QUERY="abenakireport">
#Trim(abenakireport.first_name)# #Trim(abenakireport.last_name)#
#Trim(abenakireport.street)#
#Trim(abenakireport.city)#, #Trim(abenakireport.state)#
#Trim(abenakireport.zip)#
#Trim(abenakireport.phone)#
</CFLOOP> </CFMAIL>
Thank you so much for all of your ideas.
:-)Oriole
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
