Afsende email med ASPmail
Jeg forsøger at lave en side hvor jeg sender emailud ved hjælp af aspmail. Dataene ligger i enaccesdatabase. Koden er herunder. Jeg får denne fejl (og der er en \'do\') - kan nogen hjælpe, give mig et hint om en anden kode:
Microsoft VBScript compilation error \'800a040e\'
\'loop\' without \'do\'
/mailliste190900/write_send_ny.asp, line 57
loop
^
**************start på kode** /jw
<HTML>
<HEAD>
<TITLE>Mailingliste</TITLE>
</HEAD>
<BODY BGCOLOR=\"#FFFFFF\" TEXT=\"#000000\">
<%
if request(\"mode\") = \"send\" then
\'****** VÆLG PROGRAM TIL AT SENDE MAILEN ******
\'1 = ASPMAIL
\'2 = CDONTS
mailertype = 1
\'**********************************************
Set Conn = Server.CreateObject(\"ADODB.Connection\")
conn.Open \"DBQ=\"&(Server.MapPath(\".\")) &\"mailing.mdb; DefaultDir=DBQ=\"&(Server.MapPath(\".\")) &\";Driver={Microsoft Access Driver (*.mdb)};\"
SQL = \"SELECT * from mailingliste\"
set send = conn.execute( SQL )
do while not send.eof
on error resume next
if mailertype = 1 then
Set Mailer = Server.CreateObject(\"SMTPsvg.Mailer\")
\' This is my local SMTP server
Mailer.RemoteHost = = \"din.mail.server\"
Mailer.Sender = \"afsenders emailadresse\"
Mailer.Subject = request(\"header\")
Mailer.AddRecipient send(\"email\")
Mailer.BodyText = request(\"tekst\")
if not Mailer.SendMail then
Response.Write \" E-post feil... feilen var: <br>\"
Response.Write Mailer.Response
else
Response.Write \"Mail sent.\"
end if
else if mailertype = 2 then
\' importance = 0 \' lav
importance = 1 \' normal
\' importance = 2 \' høj
Set mailObj = CreateObject(\"CDONTS.NewMail\")
\' send email med parametre : fra email, til email, header, besked, importance
mailObj.Send \"afsenders emailadresse\", send(\"email\"), request(\"header\"), request(\"tekst\"), importance
\' slet reference til CDONTS object
Set mailObj = Nothing
end if
response.write \"<FONT FACE=\'Arial\' SIZE=\'2\' COLOR=\'#000000\'><STRONG>E-mail er sendt til : \"& send(\"email\") &\"</STRONG></FONT><BR>\"
send.movenext
loop
conn.close
else %>
<CENTER>
<TABLE BORDER=\"0\">
<form action=\"write_send.asp\" METHOD=\"POST\">
<INPUT TYPE=\"hidden\" NAME=\"mode\" VALUE=\"send\">
<TR>
<TD ALIGN=\"LEFT\">
<FONT FACE=\"Arial\" SIZE=\"2\" COLOR=\"#000000\"><STRONG>
Overskrift:
</STRONG></FONT>
</TD>
<TD ALIGN=\"LEFT\">
<INPUT TYPE=\"TEXT\" NAME=\"header\" SIZE=\"50\">
</TD>
</TR>
<TR>
<TD ALIGN=\"RIGHT\" VALIGN=\"TOP\">
<FONT FACE=\"Arial\" SIZE=\"2\" COLOR=\"#000000\"><STRONG>
Tekst:
</STRONG></FONT>
</TD>
<TD ALIGN=\"LEFT\">
<TEXTAREA COLS=\"45\" ROWS=\"15\" NAME=\"tekst\"></TEXTAREA>
</TD>
</TR>
<TR>
<TD ALIGN=\"LEFT\">
</TD>
<TD ALIGN=\"RIGHT\">
<input type=\"submit\" value=\"-- SEND --\">
</TD>
</TR>
</FORM>
</TABLE>
</CENTER>
<% end if %>
</BODY>
</HTML>
**************slut på kode** /jw
