%@LANGUAGE="VBSCRIPT"%> <% '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' Spd E-Letter v4 ' © 2001, 2002 PensaWorks, inc. ' For help with this program, please visit http://www.pensaworks.com '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim Access : Access = "Broadcast" %> <% if (request("msgID") <> "" and IsNumeric(request("msgID"))) then msgID = CInt(request("msgID")) else msgID = 0 if (request("subID") <> "" and IsNumeric(request("subID"))) then subID = CInt(request("subID")) else subID = 0 if (lcase(request("format")) = "t" or lcase(request("format")) = "h") then format = lcase(request("format")) else format = "t" if (request("eml") = "Y") then emlIt = true else emlIt = false body = "" set getMessage = server.createobject("ADODB.Recordset") getMessage.activeconnection = mlConn getMessage.source = "SELECT * FROM ML_Broadcast INNER JOIN ML_Lists ON ML_Broadcast.ListID = ML_Lists.ListID WHERE ML_Broadcast.MessageID = " & msgID getMessage.cursortype = 3 getMessage.open() if getMessage.EOF then response.write "Error: Newsletter could not be found." response.end end if msgSource = getMessage("msgSource") msgFormat = getMessage("msgFormat") msgStatus = getMessage("Status") select case msgSource ' entered data... case 1 if (format = "h" AND (msgFormat = 1 or msgFormat = 3)) then if getMessage("msgIncludeTemplateHTML") = 1 then body = body & getMessage("HeaderHTML") body = body & getMessage("HTMLMessage") if getMessage("msgIncludeTemplateHTML") = 1 then body = body & getMessage("FooterHTML") else body = body & "[title]" & getMessage("Subject") & "[/title]" body = body & "[font size=2 face=Verdana, Arial, Helvetica, sans-serif]" if getMessage("msgIncludeTemplateText") = 1 then body = body & getMessage("HeaderText") body = body & getMessage("TextMessage") if getMessage("msgIncludeTemplateText") = 1 then body = body & getMessage("FooterText") body = body & "[/font]" end if ' from file... case 2 if (format = "h" AND (msgFormat = 1 or msgFormat = 3)) then if doesFileExist(getMessage("msgSourceFileHTML")) then fileData = readFileData(getMessage("msgSourceFileHTML"), fileResponse) if NOT fileResponse then body = body & "[div align=""center""][font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"" color=""#FF0000""][b]" body = "Error reading file." body = body & "[/b][font][/div][br]" else if getMessage("msgIncludeTemplateHTML") = 1 then body = body & getMessage("HeaderHTML") body = body & fileData if getMessage("msgIncludeTemplateHTML") = 1 then body = body & getMessage("FooterHTML") end if else body = body & "[div align=""center""][font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"" color=""#FF0000""][b]" body = "Error: File could not be found." body = body & "[/b][font][/div][br]" end if else if doesFileExist(getMessage("msgSourceFileText")) then fileData = readFileData(getMessage("msgSourceFileText"), fileResponse) if NOT fileResponse then body = body & "[div align=""center""][font size=""2"" face=""Verdana, Arial, Helvetica, sans-serif"" color=""#FF0000""][b]" body = "Error reading file." body = body & "[/b][font][/div][br]" else body = body & "[title]" & getMessage("Subject") & "[/title]" body = body & "[font size=2 face=Verdana, Arial, Helvetica, sans-serif]" if getMessage("msgIncludeTemplateText") = 1 then body = body & getMessage("HeaderText") body = body & fileData if getMessage("msgIncludeTemplateText") = 1 then body = body & getMessage("FooterText") body = body & "[/font]" end if else body = body & "