Fandt en løsning - har nu lavet følgende:
<%
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "dsn_name"
Set Upload = Server.CreateObject("Persits.Upload.1")
Upload.OverWriteFiles = False
sti = Server.MapPath("./../newsletter/") & "\"
Upload.Save sti
Set fil = Upload.Files("letter")
If fil is nothing Then
fil1 = ""
Else
fil1 = fil.ExtractFileName
End if
email = Upload.Form("email")
filSti = sti & fil1
'Response.Write filSti
'Response.End
If email = "Test" Then
sql = "SELECT * FROM Test"
Set rs = Connect.Execute(sql)
hilsen = "Kære"
strSlut = "Klik ind på
http://www.jupiter.scanbox.com/frames_dk for at se nyhedsbrevet."
strNoRes = "-Svar venligst ikke på denne mail-"
End if
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/frames_dk for at se nyhedsbrevet."
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/frames_no for at se nyhedsbrevet."
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/frames_se for at se nyhedsbrevet."
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/frames_sf to see the news letter."
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/frames_uk to see the news letter."
strNoRes = "-Please do not reply on this mail-"
End if
subj = Upload.Form("header")
tekst = replace(Upload.Form("tekst"), VbCrLf, VbCrLf)
do while not (rs.bof or rs.eof)
Set msg = Server.CreateObject("JMail.Message")
msg.Logging = True
msg.Silent = True
msg.From = "benteb@Scanbox.Com"
msg.FromName = "Jupiter Webmaster"
msg.AddRecipient rs("E_mail")
msg.Subject = subj
msg.Body = tekst
msg.Body = hilsen & " " & rs("Navn") & VbCrLf & VbCrLf & msg.Body & VbCrLF & VbCrLf & VbCrLf &"----------------------------------------" & VbCrLf & VbCrLf & strNoRes
msg.AddAttachment filSti
If not msg.Send("10.1.1.32") 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")
%>