EMail Address Field

[Roger Bell]

I have inherited a Data Base that has a field for EMail Address. This is
currently a Text Field. I have changed the field to a Hyerlink field and
would like to update all the data (Email address) in this field so that when
clicked the Email program will load. Is there a way I can do this without
having to edit each record and type the = sign so it is recognised as Email?

Thanks for any help

 

[Lostguy]

Sir,

Something like this:

http://www.blueclaw-db.com/download/open_email_access_outlook.htm

?

HTH VR/Lost

 

[Arvin Meyer [MVP]]

I think that you'd be better served by leaving it as a text field.
Hyperlinks use far more bytes and are stored in a different area in the
database (i.e. not in the same table) and therefore can corrupt more easily.
A bit of code, which adds the "mailto:" tag to the beginning of the string
will allow you to treat it and use it as an email address. Further, by not
using it as a hyperlink you are able to both index and sort the text.