email link

[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

 

[Dan Artuso]

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.

 

[Jim/Chris]

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

message news:[email protected]...

 

[Ashley]

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

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

message news:[email protected]...

.

.