I work this issue from the Excel Side. I have a spreadsheet where you fill in the Outlook folders to find the email and it goes out and downloads the attachments to whatever Excel folder that is filled in on this master spreadsheet.

I also have code, in a different workbook, that opens a workbook and runs the macro you specify.

These two pieces of code could be married - if you are willing to use Excel to pull from Outlook rather than use Outlook to push to Excel.