Open newest unread email in shared mailbox

Hi all

What I'm trying to achieve is when a new email comes into a shared inbox, a macro would open this email, run some code I've written which hands over to Excel and then repeat when another email comes in.
If possible, not run when specific criteria are met (such as email has come from [email protected] or subject is blank for example)

This is the code I'm currently trying which doesn't seem to work:

Please Login or Register  to view this content.

Could someone point me in the right direction please?

Thanks

Aaron