e-mail field

  • Thread starter Thread starter NHiorns
  • Start date Start date
N

NHiorns

I have an field in Access 2000 for users to enter customer
e-mail addresses. However, I would like it so that after
typing it in it automatically hyperlinks, so that email
address can be clicked on and it then opens the users
default mail program.
 
You can use the HyperLink data type, editing each value so that it becomes a
"mailto:" rather than the default "http:" hyperlink. Alternatively, you can
put these email addresses in a plain, old text type field and from a form
(which is where your users should be accessing the data) have a command
button which the users can click to send an email to the customer. In the
Double Click event for the text box containing the email address, simply put
the following code:

Dim strEmail as String

strEmail = "mailto:" & Me!CustEmail
Application.FollowHyperlink Address:=strEmail

On the form, you can format the text box containing the email address so
that it displays in another color and is underlined, making it look like a
hyperlink.

hth,
 
Back
Top