multiple e-mails based on database flag 1

davejoyce · Jun 26, 2000

I am trying to e-mail multiple contacts based on a flag in a database. It will not allow nesting of <CFMAIL> within <CFOUTPUT>. Any suggestions on how to do this?? The following code does not work:  <CFQUERY DATASOURCE="xxx">  UPDATE Broadcast_tbl  SET NewMessage = '#NewMessage#',  </cfquery>  <CFQUERY DATASOURCE="xxx" NAME="notifyusers">  select email  from personnel_tbl  where BroadcastNotify = 'Y'  </cfquery>    <CFOUTPUT>    <HTML>    <HEAD>  <TITLE> Boadcast Messages Updated</title>  </head>   <Body> <H1>Broadcast Messages Updated</h1> </cfoutput> <CFOUTPUT QUERY="notifyusers">       <CFMAIL QUERY="sendmail" TO="#email#" from="<A HREF="mailto

avid_R_Joyce@xxx.com">David_R_Joyce@xxx.com</A>" Subject="New Broadcast Message"> A new Broadcast Message Has Been Sent as Follows: #NewMessage#       </cfmail> </cfoutput> </Body> </html>     Thanks,        Dave Joyce

rjs · Jun 26, 2000

Try using CFLOOP to loop through the query which should allow CFMAIL within the loop.

achai · Jun 26, 2000

try this: <CFMAIL QUERY="notifyusers" TO="#email#" from="<A HREF="mailto

avid_R_Joyce@xxx.com">David_R_Joyce@xxx.com</A>" Subject="New Broadcast Message"> A new Broadcast Message Has Been Sent as Follows: #NewMessage# </cfmail>

davejoyce · Jun 28, 2000

achai,   It worked great, thanks for the help

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

multiple e-mails based on database flag 1

davejoyce

Programmer

rjs

MIS

achai

MIS

davejoyce

Programmer

Similar threads

Part and Inventory Search

Sponsor