Hi everyone!

I have a spreadsheet with Name, Surname, ID number, Verification Code, Employee Number, Activation Requested. I then have a mailbox in Outlook where people can send a mail confirming their ID numbers.

I would like to set up a macro that will automatically populate the Activation Requested column once a mail comes in that matches the Name, Surname, ID number fields (so the cell will either be blank or have "No" and once a mail comes in matching the above fields, it will change to "Yes").

I am quite comfortable in Excel but have only recently started to dabble with modules in VBA so by no means do I understand extensive coding or the jargon that goes along with it.

So, my questions are:

1. Is there code available that I can use to set up the above (in a step-by-step manner as I would like to understand what I am doing and not just blindly copy/paste)?

2. Would the macro run automatically once my workbook has been opened in order to update mails that may have come in when Excel wasn't running?

Thank you in advance for any advice