I was wondering if anyone could help me with this query. My VB skills are
poor but I'm sure this can be done. My question is this:

I get sent excel spreadsheets via email that contain information requests.
I am looking to see if its possible to
Use Outlook to scan an email when it arrives for a specific subject i.e
"Information Request". Automatically open this worksheet and run a macro
from within this worksheet. This macro would open a pre-designed log
spreadsheet and copy and paste certain cells from the information request to
the log sheet. This way we can keep a record of each request that comes in.

Any help would be greatfully appreciated.

Thanks in advance

Jamie