Run macro after new email

Is it possible to enable automatic macro execution (run macro) every time a new email arrives? Can something like: Private Sub Application_Startup / Triggered() be added to the code? Or at least add a command for the macro to click the blue button = (run macro) every time a new email arrives or to automatically click it every 3''? (To automatically repeat the action '- run macro - every 3'' (3 seconds)? I thought the whole code should remain only in excel so that it doesn't have to be entered into outlook?

Here is the code that works but only when the blue button is clicked.

Please Login or Register  to view this content.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer

You can reenable the ability to run a script in Outlook rules. https://www.extendoffice.com/documen...t-missing.html then assign a macro to run whenever an email is received

EDIT: as pointed out by 6StringJazzer, it is possible to utilize https://learn.microsoft.com/en-us/of...cation.newmail.

Also, Excel really isn't the right place for what you want to do. Unless you simply want to click a button and have Excel find all the new emails since the last time the button was clicked.

You can also set up a listener in Outlook code to respond to a mail received event, no need to edit the Registry for this.

the whole code should remain only in excel so that it doesn't have to be entered into outlook

But you can't do it in Excel.

If you use a timer in Excel there is no easy way to tell which emails are the new ones that have been received since the last check. It is possible, but the whole thing is easier if you drive it from Outlook.