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:248028 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
