Any reason you're using a value list instead of just looping over the query itself?
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 11:22 AM To: CF-Talk Subject: RE: Sending Email from a valuelist. Check your source code after execution... I think the emails are showing up, but the HTML page is ignoring them as <TAGS>... If this is the case, the CFMail should work fine even if OUTPUT is not showing them??? I am not sure if you are saying the email is working already or not? ........................ Ben Nadel www.bennadel.com -----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 12:00 PM To: CF-Talk Subject: Sending Email from a valuelist. to begin with I have a Query that pulls the first last names and email Addy as one field. then i pass that item to a value list for the TO field of my CFMAIL tag <cfquery name="bosses" datasource="#dsn#"> SELECT Firstname + ' ' + Lastname + ' <' + email + '>' AS useremail FROM Security WHERE (access_level = 5) </cfquery> <cfmail To="#valueList( email.useremail, ',' )#" from="#Session.useremail#" Subject="#LetterID#" cc="" bcc="" charset="utf-8" type="html" mailerid="Microsoft Outlook, Build 10.0.3416"> the output of this is simply a coma delimited list but its only seeing the first and last name and excluding the email portion. Bryan Anderson ,Richard Dillman Now if i do an Output of <cfoutput> #valueList( bosses.useremail, ',' )# </cfoutput> I get Bryan Anderson ,Richard Dillman but if i do <cfoutput query="bosses"> #useremail#<br /> </cfoutput> I get Bryan Anderson <[EMAIL PROTECTED]> Richard Dillman <[EMAIL PROTECTED]> Any ideas how to get the value list to show the email in this format? PS: yes I could just dump email only, but the users really like seeing their names in there. -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 "IF-THEN-ELSE its a way of life!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248043 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
