Hyperlink opens browser instead of Outlook

[Dale]

Using Access 2000, clicking on a hyperlink that is an
email address opens the web browser instead of Outlook.
Some email addresses open Outlook, others open the
browser in error. Does someone know why this happens and
how to fix it so that the link opens Outlook as it should?

 

[Cheryl Fischer]

Access makes the assumption that Hyperlink type fields need to go to the
internet. On the entries which are opening the browser, you will need to
right click on the value in the field and edit the hyperlink to replace the
"http://" with "mailto:".

An alternate solution (which I prefer) is to dispense with the use of the
Hyperlink field and make the email field plain, old text. Then from a form
control bound to the email field you can insert the following code behind
the Double Click event for the control:

Dim strEmail as string

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

You can format the control so that its forecolor is blue and underlined, so
that it looks like a link to something.

If you want to consider this approach, you will still need to edit your
email field even if you change its type from Hyperlink to Text to remove the
stored value which now is visible to remove the "#http://email_address.com"