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]

Reply via email to