e-mail hyperlink

[Dan]

Hello,
I'm trying to assign a field as an e-mail hyperlink, but can't seem to make
it work. When I assign it as a hyperlink in the Properties, it treats it as
a web page link. Can anyone tell me how to do this?

Thanks,
DR

 

[BruceM]

You could format the control and the field to which it is bound as text,
then use SendObject for the e-mail. The contents of the text box would be
the e-mail address. Help has more about SendObject, but it would go
something like this (maybe in a command button's Click event):

Dim strTo as String
strTo = Me.YourTextBox
DoCmd.SendObject , , , strTo

You can also add cc, bcc, and message body, and you can specify other
options such as whether the mail is to be previewed before being sent.