I need some script that would enable a macro to do the following -

a - view a specific mailbox within outlook
b - determine whether there is an excel workbook attachment
c - if attachment.......erm, attached i suppose, open the attachement

I can then write some script to pull various bits of data and drop into another worksheet from the open attachment and close down

d - Move the worked email to another mailbox
e - select next email and run process from 'b' until all new emails have been worked

Any help with all or bits of required code would be a great help.


Cheers