I've got subfolders in Outlook named like so:

Inbox
 ---105-S8J
 ---602-9HX
\---sub
    \---937-WM4

and emails in my inbox with subjects as below:

some 105-S8J text
[issue] 937-WM4 discussion
602-9HX

what I'm wanting to do is create a VBA script that will get all message subjects from inbox emails and get all folders in my mailbox that match this regex: '^[0-9]{3}-\w{3}$'

then compare and put the emails with a matching folder name into that corresponding folder.

But wait, there's more!

I don't want to move unread emails. I also do not want to move the most recent read email for each code.

Example: if I have 3 emails

1. [issue] 937-WM4 discussion <- unread
2. [issue] 937-WM4 discussion <- read
3. [issue] 937-WM4 discussion <- read

Only the third email should be moved.

I realize this is a lot to hope for, but I'm wondering if anyone has seen this done before so I don't have to start from scratch.

I have very little experience with VBA, so any direction at all would be greatly appreciated.