Email with outlook by click on emailadres

  • Thread starter Thread starter Pat Belgium
  • Start date Start date
P

Pat Belgium

If I write a email adres in a Excel cell, automaticaly
a hyperlink to mentioned mailadres is made and function
by simple click.
In Access :
If I try to change properties of a form cell or
in contentstabel in Access2000 to hyperlink,
I only get a connection with "http:internet etc...",
how to make such a cell working to connect directly
to outlook newmessage as it functions in Excel ???

Many thanks in advance, for a not to complicated answer.
 
we allready found the answer, thanks anyway

Private Sub E_Mail_DblClick(Cancel As Integer)
If Me.e_mail.Value <> "" Then
Application.FollowHyperlink "mailto:" & Me.e_mail
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top