I have a code that pulls Conversation ID from Outlook. This would represent an email that I sent through a VBA macro. I'd like to find a way to see if any of these emails have been responded to.
I have two thoughts on how this might be completed but no concept of how to complete either:
Option A: Create a function that acts as a VLookup almost - take the conversation ID from column A and return a TRUE (email received response which is in inbox) or FALSE (Email has no response in inbox) value in the selected cell. Something like =OLLookup(A2) which can be dragged down.
Option B: Make a macro that will autofill column F with the above criteria.
Is this possible??