email new message

[Craig Wilks]

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!

 

[Dick Kusleika]

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.