Kan bare poste det her:
<%
Dim subj, tekst, email, Connect, rs, hilsen, strSlut, strNoRes
Set Connect = Server.CreateObject(\"ADODB.Connection\")
Connect.Open \"jupiter\"
subj = Request.Form(\"subject\")
tekst = replace(Request.Form(\"body\"), VbCrLf, VbCrLf)
email = Request.Form(\"receiver\")
If email = \"Danmark\" Then
Set rs = Server.CreateObject(\"ADODB.Recordset\")
rs.Open \"SELECT * FROM Jupiter_club_dk\", Connect, 1, 3
hilsen = \"Kære\"
strSlut = \"Klik ind på
http://www.jupiter.scanbox.com for at se de nyeste covers til de nyeste Jupiter titler.\"
strNoRes = \"-Svar venligst ikke på denne mail-\"
End if
If email = \"Norge\" Then
Set rs = Server.CreateObject(\"ADODB.Recordset\")
rs.open \"SELECT * FROM Jupiter_club_no\", Connect, 1, 3
hilsen = \"\"
strSlut = \"Klik ind på
http://www.jupiter.scanbox.com for at se de nyeste covers til de nyeste Jupiter titler.\"
strNoRes = \"-Svar venligst ikke på denne mail-\"
End if
If email = \"Sverige\" Then
Set rs = Server.CreateObject(\"ADODB.Recordset\")
rs.open \"SELECT * FROM Jupiter_club_se\", Connect, 1, 3
hilsen = \"\"
strSlut = \"Klik ind på
http://www.jupiter.scanbox.com for at se de nyeste covers til de nyeste Jupiter titler.\"
strNoRes = \"-Svar venligst ikke på denne mail-\"
End if
If email = \"Finland\" Then
Set rs = Server.CreateObject(\"ADODB.Recordset\")
rs.open \"SELECT * FROM Jupiter_club_sf\", Connect, 1, 3
hilsen = \"Dear\"
strSlut = \"Click in at
http://www.jupiter.scanbox.com to see the latest covers for the latest Jupiter titles.\"
strNoRes = \"-Please do not reply on this mail-\"
End if
If email = \"England\" Then
Set rs = Server.CreateObject(\"ADODB.Recordset\")
rs.open \"SELECT * FROM Jupiter_club_uk\", Connect, 1, 3
hilsen = \"Dear\"
strSlut = \"Click in at
http://www.jupiter.scanbox.com to see the latest covers for the latest Jupiter titles.\"
strNoRes = \"-Please do not reply on this mail-\"
End if
do while not rs.EOF
Set msg = Server.CreateObject(\"JMail.Message\")
msg.Logging = True
msg.Silent = True
msg.From = \"Jupiter@Scanbox.Com\"
msg.FromName = \"Jupiter Webmaster\"
msg.AddRecipient rs(\"Mail\")
msg.Subject = subj
msg.Body = tekst
msg.Body = hilsen & \" \" & rs(\"Navn\") & VbCrLf & VbCrLf & msg.Body & VbCrLF & VbCrLf & VbCrLf &\"----------------------------------------\" & VbCrLf & strSlut & VbCrLf & VbCrLf & strNoRes
If not msg.Send(\"10.1.1.42\") Then
Response.Write \"<pre>\" & msg.log & \"</pre>\"
Else
Response.Write \"Beskeden er sendt!\"
End if
rs.MoveNext
loop
Set JMail = Nothing
Response.Redirect(\"news_letter_ok.asp\")
%>
Dette er hvad jeg har brugt - og det fungerer fint.
Du skal nok lige rette det til.