Re: [iMS] CF and ims and BCC/CC

[Howie Hamlin]

Currently you have to loop over the CFX.  The ability to personalize mail using a query and calling the tag once is a future enhancement.   Regards,   Howie ----- Original Message ----- From: Mark Theis To: inFusion Support List Sent: Thursday, January 11, 2001 10:11 AM Subject: RE: [iMS] CF and ims and BCC/CC Howie,   Thanx A TON!!!!!!   Now, I have another (maybe stupid) question for you.. :-)   <cfquery name="qry_GetEmails" datasource="#dsn#" dbtype="ODBC" blockfactor="100" username="user" password="pw">   SELECT      a.idno, a.companynm, a.lastname as lname, a.firstname as fname,      a.midinit, a.domainname, a.webpasswrd,      a.sponsor, a.enroller, a.rank, a.spnside,      a.email   FROM        dbo.tbl_asscinfo a     WHERE a.IDNO='1015'>   <cfx_imsmail     QUERY="qry_GetEmails"     QUERYFIELD="email"     header_To="recipient1"     header_Cc="recipient2"     header_subject="#idno# - #form.subject#"     body="#form.message#">     Ok, this is a simplified example, but it shows the point (I HOPE).   I want to send personalized emails to my user base.  substituting %name% for the name..  etc...  you can catch my meaning... different name in each version of the email message....   The question is...   Can I do this with the control?  or do I have to load the object in a loop (<cfoutput query="qry_GetEmails"> or <cfloop>)   Thanx,   Mark Theis