e-mail address to click

  • Thread starter Thread starter mail fanatic
  • Start date Start date
M

mail fanatic

I have a table with contact information and thus also e-
mail addresses
When viewing the information on a form, I want my users
to be able to click this field (e-mail adress) so it
opens Outlook with this address automatically in
the "To:" field.
this works great with Word and Excel, and I was expecting
similar functionality in Access (2002)

Apparently, I am expecting too much?
 
No, you're not expecting too much - it can be done in Access easily. I
recommend putting the following code behind the Double Click event of the
control (field) containing your email address rather than the Click event
(after all, users may Click in the control to edit an email address not to
send an email).

Dim strEmail as String

strEmail = "mailto:" & Me!EMailAddr
Application.FollowHyperlink Address:=strEmail

On your form, you can also format the control containing the email address
using a different forecolor and underscore to make it look special.

hth,
 
Back
Top