CF Mail / CF Output / CF Inquiry

Adobe Partners,

         I have MS Windows 2003 Server (32 bit) running IIS and ColdFusion MX7 on it hosted off site. I have a Catalog Reuqest Form that my users can request catalog's from us. Back in July a feature that was set up to do the following, was some how broken and I'm having issues getting it configured to work again. What I need help with is probably easy, but yet I'm having a hard time fixing it or getting it to work right. When a customer clicks on the Catalog Request form. It opens up a file called "catalog_requests.cfm" and from there in the "cfm" code it loads "catalogrequest.cfm" which in tells after the user hits submit (after entering in their information ... Name, Address, E-Mail, etc) it loads "SVCatalogRequest.cfm" which is the file that takes that data from thoses boxes and inserts it in to my MS SQL Database and then is suppose to e-mail the e-mail account I have set up with the same exact data that it just inserted into the SQL Database.

        Well the data is being inserted, but NO e-mail is being generated from it at all. If I take the code out and/or create a file called send_mail.cfm and code it using Adobe's How-To (http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00001595.htm#1096150) it works just FINE so I know the ColdFusion is correctly set up to send e-mails. But then I go back to my SVCatalogRequest.cfm and never get the e-mail after entering in my information (Name, Address, etc). So I need assistance it getting it to where it e-mails our catalog department AND insert's the data all at once.

Thanks,

Justin.4510