Have you tried removing the "mailto:"; from the address?
Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server ((())) PrismAV is Coming ((())) >>> Please vote for iMS here: >>> http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm <<<< >>> Find out how iMS Stacks up to the competition: >>> http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Hawkes, Keith A CIV" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 1:30 PM Subject: Email Variable Syntax Problem > > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
