Hi all,

Hoping somebody who knows Outlook programming can help with an issue. I'm getting pretty good with VBA in Excel and Access, but haven't done anything with Outlook so far...

I get a couple of reports emailed to me each day in CSV format, and I would like to save them in a folder based on a date that will be present in cell A2 when opened in Excel.

The reports are named "Performance - DDMMYYYY" and "Release - DDMMYYYY", however our reporting suite sometimes sends blank attachments so the date in the file name is not reliable. I could change "Performance" and "Release" to something more unique if needed.

I would like Outlook to identify these emails being received and open the attachment to check the date in A2, then save the attachment to G:/Reports/YYYY/MM/DD - [Performance/Release].CSV where the YYYY, MM, DD are those found in cell A2 and Perfomance or Release depends on the title of the report.

I would also like it to send an email to me (or notify some other way) if it finds no date in A2, so I know to run the report manually.

Regards
Duane