mailto: from table field (Access XP)

Topic

New Reply

Probably simple but it’s eluding me. I have a field in a table defined as a hyperlink. The field contains email addresses imported from Outlook using an addin. When displayed on a form, clicking the text box attempts a normal http:// connection, understandable I suppose. How can I force mailto: I don’t see any way to change the field property in the table . I’ve tried changing the control source i.e. =”mailto:”&[eMailAddress] but that doesn’t work. Any ideas? Thanks.

Reply | Quote

Replies

The problem is that if you enter name@domain.tld into a hyperlink field, it is converted internally to http://name@domain.tld (in fact, probably to “name@domain.com#http://name@domain.com#”; a hyperlink field consists of up to three parts, separated by # characters: the displayed text, the address and the sub-address). If you enter mailto:name@domain.com, it’s left that way (actually, “#mailto:name@domain.com#”)
You can repopulate the hyperlink field with mailto: followed by the e-mail address, or you can use a normal text field that stores just the e-mail address, and use
Application.FollowHyperlink “mailto:” & [eMailAdress]
in an event handler to start the e-mail.

Reply | Quote

Thanks again Hans application.followhyperlink did the trick. When I get a chance I’ll change the import.

Reply | Quote