You say you are 'trying' - so what attempt have you made? Searching Outlook emails is a fairly common topic. Review https://learn.microsoft.com/en-us/of...taining-office

Article shows code for use behind Outlook. For use in Excel, will have to modify with Outlook automation.