Try this:
<cfx_imsmail query="getlist" queryfield="email_address"
header_to="<:smtpto:>"
smtpfrom="#form.from#"
header_from="FishingWorks.com"
header_subject="#trim(form.subject)#"
body="#form.body#"
spooldir="d:/ims/out/"
warnto="[EMAIL PROTECTED]"
>
HTH,
Howie
----- Original Message -----
From: "Greg Silver" <[EMAIL PROTECTED]>
To: "inFusion Support List" <[EMAIL PROTECTED]>
Sent: Tuesday, November 13, 2001 11:26 AM
Subject: [iMS] Sending problem
> Heres my code.....
>
> <cfquery name="getlist" datasource="fishingworks">
> select distinct email_address from bulk_email
> </cfquery>
> <cfx_imsmail query="getlist"
> smtpto="#getlist.email_address#"
> header_to="#getlist.email_address#"
> smtpfrom="#form.from#"
> header_from="FishingWorks.com"
> header_subject="#trim(form.subject)#"
> body="#form.body#"
> spooldir="d:/ims/out/"
> warnto="[EMAIL PROTECTED]"
> >
>
> For some reason I had to add GETLIST.EMAIL_ADDRESS into the smtpto and
> header_to .. I got an error when using only #EMAIL_ADDRESS#. Thats problem
> #1
>
> #2 is...i see NO record in the logs of ANY emails being sent out. there is
> about 300+ email addresses in the Bulk_Email table.
>
==^=======================================================
This list server is Powered by iMS
"The Swiss Army Knife of Mail Servers"
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [email protected]
==^=======================================================