I have a form to send email to members using CDOSYS. I had it working fine with CDONTS but my new webhost requires that I use CDOSYS. The code below actually sends emails to the members but I get an error. Here is the code that I am using:
<%
server.ScriptTimeout=1800
if len(request.form) > 0 then
Dim objMail, rs
Dim MyBody
MyBody=replace(trim(reques
t.form("ma
tter")), vbCrLf, "<br />")
fnpath=Server.Mappath("db/
mydatabase
.mdb")
set aqe=server.CreateObject("A
DODB.Conne
ction")
aqe.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & fnpath
set rs=server.CreateObject("AD
ODB.Record
set")
Set objMail = Server.CreateObject("CDO.M
essage")
Set objConfig = Server.CreateObject("CDO.C
onfigurati
on")
'Configuration:
objConfig.Fields(cdoSendUs
ingMethod)
= cdoSendUsingPort
objConfig.Fields(cdoSMTPSe
rver)="smt
p.mywebhos
t.com"
objConfig.Fields(cdoSMTPSe
rverPort)=
25
objConfig.Fields(cdoSMTPAu
thenticate
)=cdoBasic
objConfig.Fields(cdoSendUs
erName)="s
endusernam
e@ptraa.co
m"
objConfig.Fields(cdoSendPa
ssword)="s
ecrectpass
word"
'Update configuration
objConfig.Fields.Update
Set objMail.Configuration = objConfig
rs.open "select MemberEmail from testmail where MemberEmail <> '""'",aqe,3,3
rs.MoveFirst
while not rs.eof
objMail.From = "myname@mywebsite.com"
objMail.To = trim(rs("MemberEmail"))
objMail.Subject = trim(request.form("subject
"))
objMail.HTMLBody = trim(request.form("matter"
))
objMail.Send
Set objMail=Nothing
Set objConfig=Nothing
wend
mailsent="true"
end if
%>
Here is the error message I get:
Object required
/massmail.asp, line 42
Another minor issue is that the email message is not saving line breaks. Everything goes on one line
Start Free Trial