Access linked to Outlook

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

I have a field that stores email addresses: [email
address] which is has a hyperlink data type property. What
I am looking for is to be able to be able to click on a
particular email address entered in the field which would
open an email new message box with the email address
showing in the "to:" box.
How can I do this. If this requires module, I have never
used them before, so the simplest way would be much
helpful, unless module creation is not that traumatising
and I could get a go at it!.

Thanks in advance.
Chris.
 
Hi Chris,

If you want this to happen with a hyperlink field you need to store the
full URL, not just the email address, e.g.

mailto:[email protected]

Otherwise, store the address in an ordinary text field rather than a
hyperlink one. On your form, set the DoubleClick property of the textbox
that displays the field to [Event Procedure] and put a line of VBA code
like this in the actual procedure:

Application.FollowHyperlink "mailto:" & Me.XXX.Value

where XXX is the name of the textbox.

(Alternatively, use a button and put the FollowHyperlink command in its
Click event procedure.)

Hi,

I have a field that stores email addresses: [email
address] which is has a hyperlink data type property. What
I am looking for is to be able to be able to click on a
particular email address entered in the field which would
open an email new message box with the email address
showing in the "to:" box.
How can I do this. If this requires module, I have never
used them before, so the simplest way would be much
helpful, unless module creation is not that traumatising
and I could get a go at it!.

Thanks in advance.
Chris.
Click to expand...
 
Back
Top