how to check if outlook email subject exists and return a text on excel thereafter

[lyl89]

I'm trying to perform a check to see if I have completed all my BAU tasks by searching the subject on outlook.

The emails subjects will be on one column. The code should pick from that column and if it exists on Outlook today, it will reflect as "Task Completed". Else "Task Incomplete".

Appreciate all the help I can get from you guys. Thanks in advance.

30303

[June7]

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/office/vba/outlook/how-to/search-and-filter/search-the-inbox-for-items-with-subject-containing-office

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