You could make the form that your sales people use to create the message have a checkbox that says "Include Customer Id"
Then in your <cfmail> body area, do something like: <cfif form.customer_check_form_field Is 1> #query.customerid# </cfif> That could resolve it maybe!? Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Ben Densmore" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 11:24 AM Subject: Best solution for this > Hi all, > I am making some changes to one of our apps that our sales people use > for emailing to customers. We have an interface that the sales people > can use to create their own emails and get stored in a db, I need to > allow the customerid that identifies the customer to be displayed in the > body of the message, but only for one particular message. Is there a way > to put my customerid into the form field that goes into the database and > be able to grab the actual value of it when it sends out the email. > Right now if I create a new email and put in #customerid# the email > displays it exactly as that. I need to show the actual value that is > there. > > Thanks, > Ben Densmore > Web Developer > eSupport.com, Inc. > (978) 686-6468 x333 > http://www.esupport.com > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists