First, you will need to determine the display name of the Outlook store which contains your search folders.
Use this code to list your stores.
Sub FindYourStore() Dim colStores As Outlook.Stores Dim oStore As Outlook.store On Error Resume Next Set colStores = Application.Session.Stores 'You may use Session.Stores as shortcut For Each oStore In colStores Debug.Print oStore.DisplayName Next End Sub
With the name of the Outlook store, you plug that into the next subroutine. In my case, I was using this routine to parse emails in this folder. This routine will list the subject lines of every email in the designated search folder.
THIS CODE ONLY WORKS WITH SEARCH FOLDERS.
Sub ListSubjectLinesOfEmailsInASearchFolder() Dim StoreName As String Dim FolderName As String StoreName = "myemail@mycorp.com" FolderName = "Pending Terminations" Dim colStores As Outlook.Stores Dim oStore As Outlook.store Dim oSearchFolders As Outlook.Folders Dim oFolder As Outlook.Folder Dim mail As Outlook.MailItem On Error Resume Next Set oFolder = Session.Stores.Item(StoreName).GetSearchFolders(FolderName) For Each mail In oFolder.Items Debug.Print mail.Subject Next End SubI hope that helps someone else out there.
6 comments:
Thanks! It was quite helpful. I even went a bit further and implemented a bit of a dynamic selection process (the next Sub is about the same, but wth the StoreName and FolderStore moved to passed variables):
Sub FindYourStore()
Dim colStores As Outlook.Stores
Dim oStore As Outlook.Store
Dim oFolder As Outlook.Folder
Dim StoreName As String
Dim FolderName As String
Dim FolderList As String
Set oFolder = Application.Session.PickFolder
StoreName = oFolder.Name
FolderList = ""
On Error Resume Next
Set colStores = Application.Session.Stores
For Each oStore In colStores
If oStore.DisplayName = StoreName Then
Set oSearchFolders = oStore.GetSearchFolders
For Each oFolder In oSearchFolders
' Debug.Print (oFolder.FolderPath)
FolderList = oFolder.Name & Chr(10) & FolderList
Next
End If
Next
FolderName = InputBox("Enter the search folder from the list:" & Chr(10) & FolderList)
ListSubjectLinesOfEmailsInASearchFolder StoreName, FolderName
End Sub
Thank you for this info team, it was really helpful for me,
visit here for more info :
Outlook Customer Care
Outlook Customer Service Number
Outlook Customer Care Number
Outlook Customer Support Number
Outlook Technical Support Number
Outlook Tech Support Number
Outlook Express Support Number
Outlook Support Number
This article is very useful for us.Thank you so much for posting! For any help regarding AOL Desktop Gold Software please follow these links:-
install aol gold desktop
Install AOL Desktop Gold
how to recover yahoo email password
yahoo email not working
yahoo mail not working on android
SSL Error While Accessing SBCGlobal Email On Google Chrome
sbcglobal email login problem
Set Up SBCGlobal Email Account
manage SBCGlobal email account on the desktop
How to Troubleshoot SBCGlobal Login Error
sbcglobal customer care number
sbcglobal customer service number
Post a Comment