Open Spreadsheet When Email Received

[Johndinho]

Hi,

I am trying to automate a particular process where when I receive an email with a particular attachment I open the email, run a macro and close the spreadsheet. (The macro migrates data to a record sheet, generates an email and sends a 3rd spreadsheet on to a predefined distribution list.

Is there a way to automatically trigger this when the email is received? I managed it once using a .bat file - cannot find it now but even then I did not open an attachment. Would I be better to use VBA in outlook?

Hope this is clear enough..

1. Email received (Either subject line or sender acts as the trigger)
2. Attachment is opened (Attachment will have code already in and a workbook open trigger)
3. Data is transfered
4. New email generated and sent

It sounds so simple when I list it like that but it is just point 1 holding me back

Any suggestions would be gratefully received..

Thanks,

John