Add a TRIM around the variable: #email_closure.email_address# It might be a space in variable.
>>> [EMAIL PROTECTED] 07/23/03 01:30PM >>> I have a query for getting customer's name to put into an autogenerated email: <cfquery name="email_closure" datasource="helpdesk"> SELECT cust_f_init + cust_m_init + cust_lname AS email_address, resolution FROM helpdeskmain WHERE ticketid = #recordset1.ticketid# </cfquery> However, when I try to insert the variable as such: <cfprocessingdirective suppresswhitespace="no"> <cfmail subject="Helpdesk Ticket #Recordset1.TicketID# Has Been Closed" from=" [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> " to=" [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> " > I get this error message: Attribute validation error for tag CFMAIL. The value of the attribute to, which is currently "KAHAWKES @rroads.med.navy.mil", is invalid. The Error Occurred in C:\Inetpub\wwwroot\INTRANET\HelpDesk\IRMD\email_test.cfm: line 248 246 : </cfoutput> 247 : <cfprocessingdirective suppresswhitespace="no"> 248 : <cfmail 249 : subject="Helpdesk Ticket #Recordset1.TicketID# Has Been Closed" 250 : from="[EMAIL PROTECTED]" Where am I going wrong? Keith Hawkes Database Administrator/Naval Hospital Roosevelt Roads ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
