Check for the senderEmailAddress

by

Dim obj as a generic Object – there are objects other than MailItem in your Inbox, also to improve your loop try using Items.Restrict Method (Outlook)

Option Explicit
Sub SetFlagIcon()
    Dim mpfInbox As Outlook.Folder
    Dim obj As Object
    Dim Items As Outlook.Items
    Dim i As Long
    Dim Filter As String
    
    Set mpfInbox = Application.GetNamespace("MAPI").GetDefaultFolder _
                                    (olFolderInbox).Folders("Temp")

    Filter = "[SenderEmailAddress] = '[email protected]'"
    
    Set Items = mpfInbox.Items.Restrict(Filter)
    
    ' Loop all items in the Inbox\Test Folder
    For i = 1 To Items.Count
        If Items(i).Class = olMail Then
            Set obj = Items(i)
            'Set the yellow flag icon
            obj.FlagIcon = olYellowFlagIcon
            obj.Save
        End If
    Next
    
End Sub

Items.Restrict Method Applies a filter to the Items collection, returning a new collection containing all of the items from the original that match the filter.

More Related Contents:

  1. Get reference to additional Inbox
  2. How to add default signature in Outlook
  3. How do I trigger a macro to run after a new mail is received in Outlook?
  4. Outlook VBA – Run a code every half an hour
  5. For Each loop: Some items get skipped when looping through Outlook mailbox to delete items
  6. Can I iterate through all Outlook emails in a folder including sub-folders?
  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. Removing a string that includes CRLF characters from body of e-mail
  16. How to insert text into Outlook email editor using VBA
  17. How do you extract email addresses from the ‘To’ field in outlook?
  18. How do I open an outlook .msg file from my harddrive that is NOT in outlook?
  19. Using visual basic to access subfolder in Inbox?
  20. When is a MailItem not a MailItem? [closed]
  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. MS Access VBA: Sending an email through Outlook [closed]
  27. Where does Outlook store the VBA code files?
  28. Working with current open email
  29. Debugging an Outlook 2007 script fired by a rule
  30. Runtime error 287. Sending Emails through Outlook using VBA in Access

Leave a Comment