If you specify QUERY as an attribute of CFMAIL you don't want to put a loop
of that same query in cfmail content. It should be as follows.
<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
#Trim(abenakireport.first_name)# #Trim(abenakireport.last_name)#
#Trim(abenakireport.street)#
#Trim(abenakireport.city)#, #Trim(abenakireport.state)#
#Trim(abenakireport.zip)#
#Trim(abenakireport.phone)#
</CFMAIL>
Mark Johnson
-----------------------
Senior Cold Fusion Developer
Cardinal Communications
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 21, 2000 7:31 PM
To: CF-Talk
Subject: QUESTION: <CFMAIL> and <CFLOOP>
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.
------------------------------------------------------------------------------
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.
