Hi
I am using the CDONTS.NewMail object to send a mail to a client with a dynamic reference number established from a SQL server dbase. This is fine and on my local machine this works fine
When I try to run the asp page fromthe server it tells me it has sent the mail but it doesnt actualy deliver.
The server is running MS Proxy server and so we all collect our mail this way.
Could this lack of mail delivery be something to do with proxy or should I add code to my asp page to indicate something else.
Here is my ASP code. I have changed th sql strings for security reasons only but the rest is the same.
<HTML>
<BODY>
<%
Set Message = CreateObject("CDONTS.NewMail"
set cap = createobject("MyObj.MyClass"
set rs=createobject("ADODB.recordset"
set rsNo = createobject("ADODB.recordset"
sql = "SQL STRING"
set rs = cap.GetRecordset(sql)
Message.From = "webmaster@capital-fusion.com"
rs.MoveFirst
Message.To = rs.fields(0)'Request.Form("email"
Message.Subject = "Request Log"
sql = SQL STRING
set rsNo = cap.GetRecordset (sql)
BodyToSend = "Your request No is: " & rsNo.fields(0) & vbcrlf & _
" " & vbCRLF & _
"Please Quote this number during any contact with Capital Fusion" _
& vbcrlf & _
" " & vbCRLF & _
"***Auto Response From dfhdfhfdfhdfh***"
Message.Body = BodyToSend
On Error Resume Next
Message.Send
If Err.Number = 0 Then
Response.Write "An E-mail has been sent to you containing your Request Log Ref No."
Else
Response.Write "Error: " & Err.Description
End If
rs.Close
rsNo.Close
set rs = nothing
set rsNo = nothing
Set Message = Nothing
%>
</BODY>
</HTML>
Please help
Nev G
I am using the CDONTS.NewMail object to send a mail to a client with a dynamic reference number established from a SQL server dbase. This is fine and on my local machine this works fine
When I try to run the asp page fromthe server it tells me it has sent the mail but it doesnt actualy deliver.
The server is running MS Proxy server and so we all collect our mail this way.
Could this lack of mail delivery be something to do with proxy or should I add code to my asp page to indicate something else.
Here is my ASP code. I have changed th sql strings for security reasons only but the rest is the same.
<HTML>
<BODY>
<%
Set Message = CreateObject("CDONTS.NewMail"
set cap = createobject("MyObj.MyClass"
set rs=createobject("ADODB.recordset"
set rsNo = createobject("ADODB.recordset"
sql = "SQL STRING"
set rs = cap.GetRecordset(sql)
Message.From = "webmaster@capital-fusion.com"
rs.MoveFirst
Message.To = rs.fields(0)'Request.Form("email"
Message.Subject = "Request Log"
sql = SQL STRING
set rsNo = cap.GetRecordset (sql)
BodyToSend = "Your request No is: " & rsNo.fields(0) & vbcrlf & _
" " & vbCRLF & _
"Please Quote this number during any contact with Capital Fusion" _
& vbcrlf & _
" " & vbCRLF & _
"***Auto Response From dfhdfhfdfhdfh***"
Message.Body = BodyToSend
On Error Resume Next
Message.Send
If Err.Number = 0 Then
Response.Write "An E-mail has been sent to you containing your Request Log Ref No."
Else
Response.Write "Error: " & Err.Description
End If
rs.Close
rsNo.Close
set rs = nothing
set rsNo = nothing
Set Message = Nothing
%>
</BODY>
</HTML>
Please help
Nev G