I have subscribed to an RSS Feed of MP3 files that I save in a sub folder of my RSS Feeds folder called "Italian Mags MP3". Each email contains an MP3 file and the first line in each email contans a code that identifies the file in the format "a MP3 yyyy-mmn" where
a is a two or 3 character code,
MP3 is a constant
yyyy-mm is the year and month of the file and
n is a further identifier of the file
What I would like is do develop an Outlook Rule or a VBA macro that runs as soon as the RSS Feed is updated that will save the attachment in a folder on my PC based on the month (mm) content of the first line of the email. Specifically the path would be C:\Users\Rob\Music\Italian\mm where mm is the month corresponding to the mm in the date component of the code.
If necessary I can easily write a VBA function that will extract the mm component I am looking for, but what I don't know is the best and easiest way to accomplish the rest, or if it is even possible.
I guess I need something that will
Check RSS Feeds as soon as they hit this folder
Run my function to determine the mm content
Save the attachment in the appropriate folder
Can anyone suggest how I do this, of if I am asking too much of Outlook