Email from Access 2000

[jkriordan]

I have a field in an Access 2000 table for email addresses. I designated the
field property as hyperlink, to make it dynamic. When I click on it, it
doesn't open OE, but opens IE istead. The email is formatted as an http
address, like this: http://[email protected]/ .

Is there any way to set up Access 2000 so that it opens my OE email client
instead?

 

[david epsom dot com dot au]

What you type into the field is not what is stored in
the field. If you want an email hyperlink, you need
to use VBA or a Query to update the field:

http://support.microsoft.com/default.aspx?scid=kb;en-us;323202
HOW TO: Change the Values in a Hyperlink Field from an HTTP Address to a
MAILTO Address in Microsoft Access 2000

(david)

 

[jkriordan]

David,

Thanks, that's what I wanted to know. But it's not working correctly. I
tried Option 1, using a Query. My email address field is named Email, so I
changed the sample to read:

IIf(Left(Email,8)<>"#mailto:","#mailto:" &
Left(Email,InStr(1,Email,"#")-1),Email)

I'm getting an Invalid Procedure Call error message from Access.

This is the first time I've created a Procedure in the program. Do I need to
tell Access where to look instructions?

John