What is the code to open MS Outlook new message by double clicking an
email address in a text box on a form. If the double clicking will not
work then a command button can be added for the code.

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Craig

In the Userform's class module, put this

Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

ThisWorkbook.FollowHyperlink "mailto:" & Me.TextBox1.Text

End Sub

Change TextBox1 to the name of your textbox.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Craig Wilks" wrote in message
...
What is the code to open MS Outlook new message by double clicking an
email address in a text box on a form. If the double clicking will not
work then a command button can be added for the code.

Craig Wilks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!