auto reply and excel macro

[Mikethelever]

I would like to automate this process whereby:

• a staff member mails an address eg (e-mail address removed) with the subject header "T605"
• Outlook received the files and starts a script whereby a query is sent to an open excel workbook and looks up "T605" in a worksheet,
• A macro is run whereby a job print/breakdown is created
• The files is copied to a new worksheet
• Replies to the sender with the new file as the attachment

I've got parts 3, 4 and the compose new messae of 5 done, just need help with the auto reply, running excel and replying to the soecific sender.

Any help would gladly be appreciated !