i have an excel file in "c:/desktop/files" where, by inputting a unique customer code, an one-page report is produced with all customer's data.

What i need, is:

1. my colleagues to be able to send an empty e-mail, via outlook 2007, with only the customer code in the subject line
2. the excel file to run (either firstly the excel file to be automatically opened or, if not possible, i should have it always running) for this customer code
3. a pdf to be produced and saved in "c:/desktop/pdf files"
4. an automatic reply to be sent to the colleague with the pdf attached.


I know this can be done as i have seen it happening in other organisations but i do not know how to do it...

any ideas for that???