You can set up an account with Windows Live Mail to do this. Hotmail.com supports POP.
`
Good luck.
I used to use messenger to notify me when a new email came in. Now that messenger has been replaced by skype, I am looking for an email program that will watch for new messages in my hotmail account and notify me with an audible alert immediately upon their arrival.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic