Can I iterate through all Outlook emails in a folder including sub-folders?

by

Something like this …

 Private Sub processFolder(ByVal oParent As Outlook.MAPIFolder)

        Dim oFolder As Outlook.MAPIFolder
        Dim oMail As Outlook.MailItem

        For Each oMail In oParent.Items

        'Get your data here ...

        Next

        If (oParent.Folders.Count > 0) Then
            For Each oFolder In oParent.Folders
                processFolder oFolder
            Next
        End If
End Sub

More Related Contents:

  1. How do I open an outlook .msg file from my harddrive that is NOT in outlook?
  2. When is a MailItem not a MailItem? [closed]
  3. Get reference to additional Inbox
  4. How to add default signature in Outlook
  5. How do I trigger a macro to run after a new mail is received in Outlook?
  6. Outlook VBA – Run a code every half an hour
  7. Download attachment from Outlook and Open in Excel
  8. Embed picture in outlook mail body excel vba
  9. How to move each emails from inbox to a sub-folder [duplicate]
  10. Save attachments to a folder and rename them
  11. Outlook Reply or ReplyAll to an Email
  12. VBA Search in Outlook
  13. How to do late binding in VBA?
  14. Distinguish visible and invisible attachments with Outlook VBA
  15. Check for the senderEmailAddress
  16. Removing a string that includes CRLF characters from body of e-mail
  17. How to insert text into Outlook email editor using VBA
  18. How do you extract email addresses from the ‘To’ field in outlook?
  19. Add a “CC recipient” to Outlook 2010 VBA
  20. Using visual basic to access subfolder in Inbox?
  21. Search structured text in Outlook body
  22. Switching the FROM Inbox
  23. How to add an embedded image to an HTML message in Outlook 2010
  24. Iterate all email items in a specific Outlook folder
  25. Restrict Outlook Items by Date
  26. VBA Outlook Mail .display, recording when/if sent manually
  27. MS Access VBA: Sending an email through Outlook [closed]
  28. Where does Outlook store the VBA code files?
  29. Working with current open email
  30. Debugging an Outlook 2007 script fired by a rule

Leave a Comment