Is there software that will alert me to when a particular email arrives?

Yahoo Messenger has an email alerter. It can play a sound, display a balloon at the tray with the title of the email, or a dialog box on the screen. You can customize it to play any sound you want