"hyperlink" data type for email addresses?

[daninthemix]

Is there an easy way to have Access format all values in a particular field with the hyperlink data type to add the mailto: prefix so you can just click on the links to email someone?

 

[Hayley Baxter]

This post may be of interest to you.

http://www.access-programmers.co.uk/forums/showthread.php?t=33648&highlight=hyperlink

Hay

 

[Oldsoftboss]

Hi Hayley, haven't seen you here lately,

Dave

 

[Hayley Baxter]

Hi Hayley, haven't seen you here lately,

Dave

I've been here the whole time Dave

Hope all is well in Oz!

Hay

 

[Oldsoftboss]

Are you saying I am a male that doesn't pay attention
Never.

Things are good. Just changed jobs, so new chalenges ahead. Wife and kids are good. Weather at the moment is great - mid 30's (C)

 

[Hayley Baxter]

Are you saying I am a male that doesn't pay attention
Never.

Only on bumpy roads perhaps......

Things are good. Just changed jobs, so new chalenges ahead. Wife and kids are good. Weather at the moment is great - mid 30's (C)

Excellent glad to hear it

Hay

 

[ghudson]

I suggest that you store the email addresses in a table field that is formatted as TEXT. Then you can use the OnClick event of the text box or place a small email button besides the text box to wrap the MailTo function with the value of the text field. This example uses a text box named txtEmail...

Application.FollowHyperlink "mailto:" & Me.txtEmail

If you had searched the forum for the keyword MAILTO then you would have found a ton of threads to point you in the right direction.

 

[Oldsoftboss]

Only on bumpy roads perhaps......

Distracted on bumpy roads, I think

Cheers Hayley

 

[Hayley Baxter]

Distracted on bumpy roads, I think

Cheers Hayley

I hope you don't drive on bumpy roads, that could equally be as scary as being in a car with our Lyns

By the way....I am here today....incase you hadn't noticed that is......

Hay