When I open a new case with a vendor of ours, I get a barrage of emails over time that deal with each of the unique case numbers. What I am looking for is some help with some code that would read the subject line, looking for "Ticket #" which is then followed by a unique number for this ticket. What I then want to do is to create a subfolder for that ticket number (if one doesn't already exist) and then file each of the emails I receive automatically in the correct folder.

Example:

Subject Line: Ticket # 00044862: [ref:00D3jPA.50085KBiC:ref] - Project Type has two listings

would get filed in a folder called "Ticket 44862".

I have an Outlook rule that moves all these messages into a folder called "Aprimo Support" but this folder is getting out of control and is difficult to manage.

I am using Outlook 2003.