Execute macro on receipt of email

[ScubaStephen]

Hi,
I get an Excel spreadsheet every morning. The subject of the email is identical day in and day out. Does anyone know how to force Microsoft Outlook to listen for this email (based on the subject) and then open the attached spreadsheet and run a separate macro on it upon receipt of the email?

Any help or ideas is much appreciated
-Stephen

 

[Richard Schollar]

Hi

You can do this by creating a Rule in Outlook (Tools>Rules Wizard) and using some script code created using Outlook VBA. The following has brief details how you do this:

http://support.microsoft.com/kb/306108

 

[ScubaStephen]

Much thanks. Useful.