3 Replies Latest reply on May 15, 2007 2:25 PM by insuractive

    CFMAIL problem with Firefox

    kiorajulie
      I am having problems with a page that sends out emails to multiple users in a contact database. The process works great in IE, but when I try to do it in Firefox the emails are not going out. I do not get any error message. I am taken to a results page that tells me the emails were sent, but they do not go through. The code is pasted below, if any one has any ideas I would really appreciate it. Like I said, the emails go through when I send them in IE, but not Firefox.

      <CFSET RecList="">
      <CFIF isDefined("FORM.subId")>
      <CFSET DBList=#FORM.subId#>

      <CFQUERY NAME="sltNewsletter" DATASOURCE="#APPLICATION.ds#" USERNAME="#APPLICATION.username#" PASSWORD="#APPLICATION.password#">
      EXEC getNewsletter @letId=#letId#
      </CFQUERY>

      <CFQUERY NAME="getSubscribers" DATASOURCE="#APPLICATION.ds#" USERNAME="#APPLICATION.username#" PASSWORD="#APPLICATION.password#">
      SELECT * FROM Subscribers WHERE subId IN (#DBList#)
      </CFQUERY>

      <CFSET emailText="#sltNewsletter.letBody#">
      <CFSET emailText=ReReplace(emailText, "##", "####", "ALL")>
      <CFSET emailText=Replace(emailText, "####subFirstName####", "##getSubscribers.subFirstName[x]##", "ALL")>
      <CFSET emailText=Replace(emailText, "####subLastName####", "##getSubscribers.subLastName[x]##", "ALL")>

      <CFLOOP FROM="1" TO="#getSubscribers.recordcount#" INDEX="x">
      <CFSET thisTo="#getSubscribers.subEmail[x]#">
      <CFIF #getSubscribers.subFirstName[x]# NEQ "" AND #getSubscribers.subLastName[x]# NEQ "">
      <CFSET thisTo="#getSubscribers.subFirstName[x]# #getSubscribers.subLastName[x]# <#thisTo#>">
      </CFIF>
      <CFMAIL FROM="#sltNewsletter.letFromName# <info@presidio1031.com>" TO="#thisTo#" SUBJECT="#sltNewsletter.letSubject#" TYPE="HTML">
      #evaluate(de(emailText))#
      </CFMAIL>
      <CFSET thisTo=Replace(thisTo, "<", "(")>
      <CFSET thisTo=Replace(thisTo, ">", ")")>
      <CFSET RecList=ListAppend(RecList, thisTo)>
      <CFQUERY NAME="updSubscribers" DATASOURCE="#APPLICATION.ds#" USERNAME="#APPLICATION.username#" PASSWORD="#APPLICATION.password#">
      INSERT INTO Sub_gotNews ( gotThisMonth, subId, letId)
      VALUES (1, #getSubscribers.subId[x]#, #sltNewsletter.letId#)
      </CFQUERY>
      </CFLOOP>

      </CFIF>