MS Access: I added a field to enter an e-mail address. How can I click on it and have outlook open a new email

So I created this field on the form and made the field a hyperlink on the table. (not sure if I should change it) basically I want access to open a new outlook e-mail with that address.
MS Access: I added a field to enter an e-mail address. How can I click on it and have outlook open a new email
Use the shell command (look it up under help) to open up Outlook.





You will then need to use the sendkeys method to get to the correct field (the 'to' field of outlook) then use sendkeys with the variable stored in the field you had hyperlinked to automatically load the email address.





This is the simplified version, it's actually neat code. I've done a lot like it, and it's pretty rewarding once you get it working.





If you're into DDE there's a more seamless method, but I haven't much gotten into that myself.
Reply:This is not a good practice.


Set your field to text and in your code use the html link tag(%26lt;a href=""%26gt;%26lt;/a%26gt;)