Hyperlink Field -- MailTo Protocol 1

[LarryDeLaruelle]

I am trying to set up a hyperlink field to use the MailTo protocol.

I have set the field type to Hyperlink and in the After Update event for the field (on the input form) I concatenate the MailTo with the address:

eMail = "MailTo:" & eMail.

However, it seems to still be using the http protocol; when I click on the link, it opens the web page and not Outlook (our e-mail system).

If I enter 'MailTo:emailname@domainname' directly into the field it displays only the 'MailTo:' text, but the link works fine opening to a new Outlook email.

(I've also tried using an unbound text box as the entry field and then concatenate "MailTo:" & txtEmail into the email field. That link seems to be dead.)

Short of having the user enter the 'MailTo:' text as part of the address, how do I get this to work?

Thanks. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[danvlas]

Try:
eMail = "#MailTo:" & eMail & "#"

or (better)

Sub eMail_Click()
FollowHyperlink "MailTo:" & eMail
End Sub

or

Sub eMail_Click()
On Error Resume Next
DoCmd.SendObject,,, eMail
End Sub

Good luck



Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[LarryDeLaruelle]

Bingo.

Thanks Daniel, that did the trick. Larry De Laruelle
ldelaruelle@familychildrenscenter.org