email

[Mitre]

hi me again..
the next task of my projectis to display particulars from access table onto a web page(using SQL)... the thing is ppl must also be able eg. click on their email then immediately be able to email tat person.

The access table is constantly changing => different no. of rows of data.(people) any ideas on this matter? hope i am not too confusing

[Johnny101]

are the users going to be sending the email or just clicking a button on your web page that instructs your code to send an email to the person they choose? if they are going to be sending the email, then take this example as a roadmap to how you'd do it for real:

<a href="mailto:MyAddress@Mydomain.com">Email MyAddress</a>

when the user clicks on that link in the browser, a new email message will popup wit that address in the "To" text box. they supply the text and they click Send to send it.

if, on the other hand, you'll be sending the email - you need place all the options into a FORM tag and then check the value of it. then you'd use the CDONTS.NewMail object to actually send the email. There are other third party email objects available, such as ASPMail from www.ServerObjects.com, but CDONTS is free and it works pretty well. they are both very easy to use. do a search through the forum for specific examples of how to use them.

hope this helps,

john

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

[Mitre]

Below is the code that i have written... but it din work.... i wanted to use the acess table to display as well as be able to use the "email" column for users to be able to contact tat same person on the same table.... Anyone knows wats my mistake?






<a href="mailto:">&nbsp;

[Johnny101]

try this instead:

&lt;%
Do While Not RS.eof
Response.Write "&lt;TR>" & vbcrlf & vbtab & vbtab
Response.Write "&lt;TD>&lt;font color=""#006699"">" & RS.Fields("name").Value & "&lt;/font>&lt;/TD>" & vbcrlf & vbtab & vbtab
Response.Write "&lt;TD>&lt;font color=""#006699"">" & RS.Fields("job").Value & ">&lt;/font>&lt;/TD>" & vbcrlf & vbtab & vbtab
Response.Write "&lt;TD>&lt;font color=""#006699"">" & RS.Fields("contact").Value & "&lt;/font>&lt;/TD>" & vbcrlf & vbtab & vbtab
Response.Write "&lt;TD>&lt;a href=""mailto:" & RS("email").Value & """>" & RS.Fields("email").Value & "&lt;/a>&nbsp;&lt;/TD>" & vbcrlf & vbtab
Response.Write "&lt;/TR>"

RS.MoveNext
Loop
%>





John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

[askus]

its quite simple u got to use the mailto keyword, check if your web server has CDONTS access. if you have any concerns mail me, i can communicate further.

The Ultimate Solution Providers

Author
Sriman & Balaji

Email : solutionproviders@hotmail.com
solutionproviders@yahoo.com