Application.ActiveExplorer method (Outlook)
Returns the topmost Explorer object on the desktop.
expression A variable that represents an Application object.
An Explorer that represents the topmost explorer on the desktop. Returns Nothing if no explorer is active.
Use this method to return the Explorer object that the user is most likely viewing. This method is also useful for determining when there is no active explorer, so a new one can be opened.
The following Microsoft Visual Basic for Applications (VBA) example uses the Count property and Item method of the Selection collection returned by the Selection property to display the senders of all mail items selected in the active explorer window. To run this example, you need to have at least one mail item selected in the active Explorer window.
Note You might receive an error if you select items other than a mail item such as task request as the SenderName property does not exist for a TaskRequestItem object.
Sub GetSelectedItems() Dim myOlExp As Outlook.Explorer Dim myOlSel As Outlook.Selection Dim MsgTxt As String Dim x As Integer MsgTxt = "You have selected items from: " Set myOlExp = Application.ActiveExplorer Set myOlSel = myOlExp.Selection For x = 1 To myOlSel.Count MsgTxt = MsgTxt & myOlSel.Item(x).SenderName & ";" Next x MsgBox MsgTxt End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.