query attribute, and you can use it just like CFOUTPUT, including the
attributes:
<cfquery name="get">
select email
from contacts
</cfquery>
<cfmail query="get"
to="#email#"
from="[EMAIL PROTECTED]"
subject="test">
Test message
</cfmail>
> -----Original Message-----
> From: Kathy Wargo [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 06, 2004 1:03 PM
> To: CF-Talk
> Subject: CFMiail Multiple receipents
>
> I am having serious trouble with mutiple receipents. Could
> some provide
> some insight to this problem?
>
> <cfif recipient IS "all">
> <cfquery name="getcontacts" datasource="tmc_poolfund"
> dbtype="ODBC">
> Select *
> From Contacts
> Where active = 1
> </cfquery>
>
> <cfoutput query="getcontacts" group="getcontacts">
> <cfmail
> to="#getcontacts.E_mail#"
> from="#form.from#"
> subject="TMCPFS: #form.subject#"
> cc="[EMAIL PROTECTED]"
> type="HTML">
> <p>#form.body#</p>
> </cfmail>
> </cfoutput>
>
> <cfelseif recipient IS "one">
>
> <cfquery name="getcontacts" datasource="tmc_poolfund"
> dbtype="ODBC">
> Select *
> From Contacts
> Where E_mail = '#E_mail#'
> </cfquery>
> <cfmail
> to="#E_mail#"
> from="#from#"
> subject="TMCPFS: #subject#"
> cc="[EMAIL PROTECTED]"
> type="HTML">
> <p>#body#</p>
> </cfmail>
>
> </cfif>
>
>
>
> Kathy Wargo
> KMW ASSOCIATES
> 410-280-2763
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
