Kode fra Cdonts til Jmail
Er der nogle der kan hjælpe med at lave nedenstående kode om så den kan kører med Jmail*************************
<% Server.ScriptTimeout = 1800 %>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("SpawnedMailer.mdb")
Dim mFrom,mTo,mSubject,mbcc,mBody,mArchive
mFrom = Request.Form("myemail")
mTo = Request.Form("to")
mSubject = Request.Form("subject")
mbcc = Request.Form("users")
mBody = Request.Form("body")
mArchive = Request.Form("archive")
response.write("Nyhedsbrevet er sendt til:<br><br>" & mbcc )
strSQL = "SELECT MailingAddy, MailingID FROM MailingList"
set Res = Conn.Execute(strSQL)
while not Res.EOF
Set Mail = Server.CreateObject ("CDONTS.NewMail")
Mail.From = mFrom
Mail.To = res("MailingAddy")
Mail.Subject = mSubject
Mail.Body = mBody & "----------------------------------------------------------------------------" & vbcrlf & "Ønsker du at ændre din Email addresse kan du trykke på det her link: " & vbcrlf & "http://pcssm/mail/MailEdit.asp?Action=Redigere&num=" & res("MailingID") & vbcrlf & vbcrlf & vbcrlf & "STOP med at modtage dette nyhedsbrev. Klik her:" & vbcrlf & "http://pcssm/mail/MailEdit.asp?Action=Slet&num=" & res("MailingID")
Mail.BodyFormat = 1
Mail.Mailformat = CDOMailFormatMIME
Mail.Send
Set Mail = Nothing
Res.MoveNext
wend
if mArchive = "1" then
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("SpawnedMailer.mdb"))
ArchiveSQL = "INSERT into Archive (ArchiveSubject,ArchiveBody) VALUES ('" & mSubject & "','" & mBody & "');"
conn.Execute ArchiveSQL
response.write("<br><br><br><font color='#FF0000'>Brevet er nu Arkiveret!</font><br><br>")
conn.close
end if
response.write("<br><br><br><center><a href='AdminIndex.asp'>ADMIN HOME</a><center>")
%>
