Click hyperlink field on a form and have it open an Outlook email window to that email address

You can't force Outlook to open, but a mailto: tag will open the user's default mail application if one is set up.

Outlook will be open already.  What is the onclick code to make Outlook have the email address in the To: field

It's in the link I posted.

mailto:someone@example.com?Subject=Hello%20again

Do not use the hyperlink data type.  Change it to a standard text field.  In the click event (or preferably the double-click event) use the FollowHyperLink method.  This command recognizes any valid file extension, url, or email address and opens the appropriate application.

On the form, the Hyperlink property simply specifies how the control will be displayed.  It doesn't do anything else.  You must add your own code to open the document.

I suggested the double-click event because even though you want it to act like a hyperlink, if you use the single click, you won't be able to actually edit the value easily because trying to click into the control will cause the hyperlink to be activated.  If you can train your users to always use the tab key to move from control to control, you would be able to get focus into the control and start typing but you still could never click into the center to change a couple of characters.

I'll use double-click but I don't know how to code it.

Doesn't want to work.  I do not have the field set as a hyperlink but when I double-click the email address I get:


And then when I click "Yes" I get:

The value is incorrect.  It needs to be either what is to the left of the # or what is to the right.  The security message is caused by your macro settings.

I found the mistake in the table field value.  Once I fixed it all is fine.  Thanks.