email new message

  • Thread starter Thread starter Craig Wilks
  • Start date Start date
C

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
 
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.
 
Back
Top