Avatar billede artery_graphics Nybegynder
11. oktober 2002 - 01:56 Der er 3 kommentarer og
1 løsning

Mailformular fra en Access DB

Er det ikke muligt at lave en mailformular der trækkes ud af en Access DB? Jeg har forsøgt men formularen og dens asp koden opstræder som off-line. (!)
Avatar billede terry Ekspert
11. oktober 2002 - 09:19 #1
what is a mailformular? Where do you want to use this form, if it is in a WEB application then I suggest you move your question to ASP programming!

Otherwise we are going to need more information
Avatar billede artery_graphics Nybegynder
11. oktober 2002 - 11:58 #2
This is a mailformular:

<form name="Form" action="mailhandler.asp" method="post">
<span class="mailform">Name</span><br>
<input name="name" type="text" size="35" maxlength="75" id="input" value="<%= request.querystring("sSender") %>"><br>
<br>
<span class="mailform">Your mail address</span><br>
<input name="email" type="text" size="35" maxlength="75" id="input" value="<%= request.querystring("sMail") %>"><br>
<br>
<span class="mailform">Subject</span><br>
<input name="subject" type="text" size="35" maxlength="75" id="input" value="<%= request.querystring("sSubject") %>"><br>
<br>
<span class="mailform">Message</span><br>
<textarea name="body" cols="34" rows="7" id="input"><% Body=Replace(Request.Form("body"), vbCrLf, "<br>") %></textarea><br>
<br>
<input type="image" onMouseOver="this.src='images/ok2.gif';" onMouseOut="this.src='images/ok.gif';" src="images/ok.gif" onfocus="this.blur( )" border="0" width="30" height="23"></td>
</form>


MAILHANDLER:

<%
Dim sprog, Sendername, Senderemail, Subject, Recipient, Body

Sendername=Request.Form("name")
Senderemail=Request.Form("email")
Subject=Request.Form("subject")
Recipient = "information@theselfimages.com"
Body=Replace(Request.Form("body"), "<br>", vbCrLf)


'Tjekker om der er indhold i formularens felter
IF Sendername = "" THEN
    Response.Redirect "mail.asp?sSender=" & Sendername & "&sMail=" & Senderemail & "&sSubject=" & Subject & "&sBody=" & Body & ""
END IF

IF Senderemail = "" THEN
    Response.Redirect "mail.asp?sSender=" & Sendername & "&sMail=" & Senderemail & "&sSubject=" & Subject & "&sBody=" & Body & ""
END IF

IF Instr(1, Senderemail, "@") = 0 THEN
    Response.Redirect "mail.asp?sSender=" & Sendername & "&sMail=" & Senderemail & "&sSubject=" & Subject & "&sBody=" & Body & ""
END IF

IF Subject = "" THEN
    Response.Redirect "mail.asp?sSender=" & Sendername & "&sMail=" & Senderemail & "&sSubject=" & Subject & "&sBody=" & Body & ""
END IF

IF Body = "" THEN
    Response.Redirect "mail.asp?sSender=" & Sendername & "&sMail=" & Senderemail & "&sSubject=" & Subject & "&sBody=" & Body & ""
END IF

IF Trim(Body) = "" THEN
    Response.Redirect "mail.asp?sSender=" & Sendername & "&sMail=" & Senderemail & "&sSubject=" & Subject & "&sBody=" & Body & ""
END IF



Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "mail.theselfimages.com"
JMail.Sendername = Sendername
JMail.Sender = Senderemail
JMail.Subject = Subject
JMail.AddRecipient Recipient
JMail.Body = Body
JMail.Priority = 3
JMail.AddHeader "Originating-IP", Request.ServerVariables("REMOTE_ADDR")
JMail.Execute
%>
Avatar billede terry Ekspert
11. oktober 2002 - 12:09 #3
well that looks more like ASP to me so I would think you will get an answer faster if you mov eyour question to ASP programming
Avatar billede artery_graphics Nybegynder
13. oktober 2002 - 17:51 #4
Spørgsmålet er lukket.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester