do something when new email is received in outlook

Hi,
Does anyone know how to have excel do something (like msgbox a message), whenever outlook receives a new email?

I've been trying to figure this out for a while, but can't seem to get anywhere.

Thanks in advance!

Add the following code to ThisOutlookSession object in Outlook. You need to reference the Microsoft Excel Object Library in Outlook.

Please Login or Register  to view this content.

Where MailPopup is a sub located in an open Excel workbook.

Please Login or Register  to view this content.

Thanks mojo249! I have a question: What do you mean by "need to reference the Microsoft Excel Object Library in Outlook"?

Open Outlook and press Alt -F11. Select Tools --> References menu and tick the Microsoft Excel Object Library option.

It defines the terms for referring to Excel in your code.

Thank you very much! The code works perfect!
Just one thins: I was wondering if it's possible to display the new email subject in the message box?

Hi everyone! Just wanted to ask if it's possible to do this but by replying to the email received? Basically what I want to do is when a specific message with a voting option arrives in my inbox, I can send an automatic reply.