email Link from field

  • Thread starter Thread starter Les
  • Start date Start date
L

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
 
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.
Click to expand...

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
 
Thanks for that Peter.

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

Les
 
Back
Top