visual basic automatically run when email received

[damgog]

I am not very experienced with visual basic and I hope that someone can help me.

This is the situation:
When an email is received from a particular source, I would like the attached file to be saved in a particular folder, eg. c:\attachments. This should happen automatically, and the user should then be shown a prompt to inform them that the attachment has been saved. The attached file should be saved in the same folder each time.

I am using the visual basic editor in Excel.

Any help would be greatly appreciated.
Thanks