hyperlink as an email?

[dgirl1010]

I have a really dumb question, please forgive me if I'm in the wrong forum.

I have a table where I store a list of contacts, including their email addresses. I'd like to be able to just click on the address and have a new email open with that address in the TO line. Is this something I can do with the format of the table, or do I need to do some VBA coding on the form that I have for users to access the information?

 

[Remou]

How about a little code?

Sub txtEmail_Click()()
strMail = "mailto:" & me.txtEmail
Application.FollowHyperlink strMail 
End Sub

 

[dgirl1010]

Thanks that worked. I did have to change the format in the table from hyperlink to text though.