email link

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

Hi,

I have a subform with a list of user names and their email
addresses.
I would like to be able to click on an email address and
it will open up the outlook with the email address that I
have clicked. How can I set this up in the subform?

Thanks
Ashley
 
Hi,
You can use the Sendobject function in the click event for the text box
that displays the address.

DoCmd.SendObject acSendNoObject, , , Me.Customer

Just replace Customer with the name of your text box
and once again, the above code will go in the Click event.
 
Her is one from Fred

Code the Double-click event of the form control that shows
the field:

Application.FollowHyperlink "Mailto:" & [ControlName]

Making corrections to the text field is much easier than
editing a
hyperlink field.

Jim
-----Original Message-----
Hi,
You can use the Sendobject function in the click event for the text box
that displays the address.

DoCmd.SendObject acSendNoObject, , , Me.Customer

Just replace Customer with the name of your text box
and once again, the above code will go in the Click event.

--
HTH
Dan Artuso, Access MVP


"Ashley" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Jim,
Where can I put the subject on this line of code?
Ashley
-----Original Message-----
Her is one from Fred

Code the Double-click event of the form control that shows
the field:

Application.FollowHyperlink "Mailto:" & [ControlName]

Making corrections to the text field is much easier than
editing a
hyperlink field.

Jim
-----Original Message-----
Hi,
You can use the Sendobject function in the click event
Click to expand...
for
the text box
that displays the address.

DoCmd.SendObject acSendNoObject, , , Me.Customer

Just replace Customer with the name of your text box
and once again, the above code will go in the Click event.

--
HTH
Dan Artuso, Access MVP


"Ashley" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
.
Click to expand...
.
Click to expand...
 
Back
Top