How to Create Sound Alert and Email Alert when Macro is Finished
 

Here is a link to John Walkenbach's info about playing wave files. I have
used this technique to add all sorts of sounds to spreadsheets.

http://j-walk.com/ss/excel/tips/tip59.htm

You can download custom spoken wavefiles from he

http://public.research.att.com/~ttsweb/tts/demo.php

Never tried the email....