How to check list sender?

I have list master file for check list sender from list.
If today Tom@gmail.com sender mail to me.
I want to flag = Y in row sender = Tom
but if today John not send mail to me write flag = N in row sender John

image

Any Idea?

Hi @fairymemay

I need to check one thing, do item.Sender.ToString gives the extact name u need ?, where item is mail message?

Hi @fairymemay

Here is the steps i thought,

  1. use get imap mail message or get outlook mail message activity, it will give list(mailmessage)
  2. check if the date of the mail is today and sender is Tom@gmail.com.
  3. if it matches update the data in the excel

Thanks