you were right just me being over cautious and testing without sending the email yes it works fine. Odd that it doesn't display in the output tho.
On 7/28/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > > 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:248042 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
