Outlook New Email event listener
I'm building a reminder tool in Excel using Outlook to send data to a user. The user's response data needs to return by the same avenue, through Outlook. To pass the response data from Outlook back to Excel I need to set up some sort of event listener to accomplish the following goals:
1. Target and bind to the most current email. (This will only ever contain response data from users)
2. Move the binded email to a separate folder (outside of the Inbox).
3. Pass the binded email item to a separate macro for further processing. I've built a macro that pulls apart the subject line and the body text so that it can be passed into Excel more easily.
4. Continue listening for more emails in the Inbox.
Tl;dr: I need an event listener that will bind to the most current email item - at some point during the macro's execution it needs to move that binded mail item to a separate folder outside of the main Inbox.
In my own research I've discovered that everything I want to do is totally possible to achieve within the scope of VBA. I'm getting lost putting the pieces together.
Any help or guidance is deeply appreciated.