Hi all, I am looking for a solution to a work problem that occurs each month. We run a a production run of data quality issues to a group email inbox, I then move the emails to a sub folder (split emails) within my inbox. All the emails are received from the same address PRODHR1. The emails will either contain one email address HRDQ1..., or multiple addresses HRD1... or HRDQ2... or HRDQ3... or HRDQ4... I need to segregate any email that was sent to more than just the HRDQ1 address

I need a macro to look in my inbox -folder "split emails" and move any email that was sent to more than the HRDQ1 email address (ie move the emails that contain multiple addresses - HRDQ1, 2,3 and 4 emails) and move to then to the folder - my inbox - "Review" folder. The emails need to be spilt leaving single HRD1 emails in the split emails folder and all the other email moved to the "Received folder. If the email contains more address than HRDQ1 then move it.



Example result should look like this:


Split emails Folder:
HRD1...HRDQ2...HRDQ3...HRDQ4...
HRD1
HRD1
HRD1...HRDQ2...HRDQ3...HRDQ4...
HRD1...HRDQ2...HRDQ3...HRDQ4...


Run macro


Split emails Folder Result
HRD1
HRD1

Review Folder Result:

HRD1...HRDQ2...HRDQ3...HRDQ4...
HRD1...HRDQ2...HRDQ3...HRDQ4...
HRD1...HRDQ2...HRDQ3...HRDQ4...

Appreciate any thoughts or assistance.

Cheers
Odd