email Link from field

[Les]

I have a field named txtemailaddress.

I would like the user to be able to Double Click on the field and
automatically start Outlook with a New email already addressed.

Could someone please give the code for this action.

Thanks

Les

 

[Peter Doering]

I have a field named txtemailaddress.

I would like the user to be able to Double Click on the field and
automatically start Outlook with a New email already addressed.

Simple solutions:

DoCmd.SendObject , , acFormatRTF, Me!txtemailaddress.Value, , , , , True
or
Application.FollowHyperlink "mailto:" & Me!txtemailaddress.Value

Professional solution:

http://www.mvps.org/access/modules/mdl0019.htm

HTH - Peter

 

[Les]

Thanks for that Peter.

I used the second method, but it would only work if I put the Field Name in
[]

Les