How can I make ASP return a Hyperlinked email field

Posted on 1999-01-11
Last Modified: 2013-12-25
I am a newbie to database programming, so please explain your answer thoroughly- thanx:)  I am starting to put together an intranet for the company I work for.  The heart of my problem lies at creating a directory with email search feature.  I can get the results to come up properly (FirstName, LastName, and EmailAddress), however, I would like the email address to hyperlink to the users mail program and automatically providing the email address in the TO: text box.  I have searched a long time for the solution to this problem, but have come up empty.  This is my last hope.  Thanx to all that attempt to help me.
Question by:sbernado
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 10

Expert Comment

ID: 1857894
I will assume the database recordset is called "RS" and the field name is called "EMail":

<A HREF="mailto:<%=rs("EMail")%>"><%=rs("EMail")%></A>

this will create an email link to the person with the email as a hyperlink.

Author Comment

ID: 1857895
Sorry MasseyM, but this did not work for me.  I am using FP98 if that makes a difference. This may be partly due to my lack of knowledge about setting up databases. I am guessing by viewing the code that my recordset is called fp_rs(i changed your code and tried it but that didn't work either).  Any further help is greatly appreciated, and I will be happy to give you the points the second it works!

Author Comment

ID: 1857896
MasseyM - You were right!  I got it too work!  You are a genius!  Please lock the questin again so I can award you the points.  Thanx a MM!!!

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

LVL 10

Expert Comment

ID: 1857897
Can you email the database and asp page to me?  I will see what I can do.

(Zipped format will work fine.)

- matt
LVL 10

Accepted Solution

MasseyM earned 100 total points
ID: 1857898
Sorry... I guess I was looking at a cached page... You're welcome.


Author Comment

ID: 1857899
Thanx Again!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question