I am looking for an Outlook VBA that will open a Excel file I have once a certain email is received, (unique subject and sender).

I can set up another Outlook folder other than Inbox if needed (Trigger Folder), and could create a rule to move that email into that folder if that would make it easier. Then the file could open as a new email is sent into that folder.

Please note, this macro will be on a remote server so I am hoping it will run for a few days at a time without having to go into my email. Will that work even if the email message remains as an unread status?