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.

9wrpZ.png