Macro to Target Newest Email Item in Inbox, Process Target, move Target to subfolder

I need someone to walk me through attaching to the selected mail item and the procedure to move the mail item to a subfolder.


I'm really new to the Outlook COM and VBA for that matter...

Previously I was able to get away with simply targeting whatever was currently selected by a user, using a mouse to click and highlight an item, and then do some processing on that item. My needs have become more complex now.

I need to set up a listener in my main inbox folder to target the newest email item. I need to break out the subject and body text of the email. I've got the code for that solidly down pat. My issue is this with building this listener, correctly targeting the newest mail item, and then moving that item to a specified subfolder of my Inbox.

These broken out subject and body strings will later be passed to an Excel macro for further data management/processing.

Please Login or Register  to view this content.

This above block is the best I've managed to cobble together using several internet sources.