Consulting

Results 1 to 2 of 2

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

  1. #1
    VBAX Newbie
    Joined
    Nov 2022
    Posts
    1
    Location

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

    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

  2. #2
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    372
    Location
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •