viktoryeung
11-22-2011, 03:07 PM
Hello,
I want to initiate an Outlook search, by clicking an Excel userform label that has a search value.
Search results displayed in Outlook. Not importing any data to Excel.
Can you help? : pray2:
Private Sub LB_EmailAddress_Click()
'Clicking this Excel UF label would initiate an Outlook search for the label value
Dim EmailAddress As String
EmailAddress = Me.LB_EmailAddress.Value
'1 activate Outlook
'2 enter EmailAddress into Outlook search bar
'3 execute search
End Sub
I want to initiate an Outlook search, by clicking an Excel userform label that has a search value.
Search results displayed in Outlook. Not importing any data to Excel.
Can you help? : pray2:
Private Sub LB_EmailAddress_Click()
'Clicking this Excel UF label would initiate an Outlook search for the label value
Dim EmailAddress As String
EmailAddress = Me.LB_EmailAddress.Value
'1 activate Outlook
'2 enter EmailAddress into Outlook search bar
'3 execute search
End Sub