jmatthews, I can't help you with athe code you want, but someone from this forum I think it was john55 (apologies if it was someone else) post this link to some very useful codes about emailing
http://www.rondebruin.nl/sendmail.htm
I do use a very succesful auto email code which sends out a message when a date in a certain cell is reached or has past which you or someone else might be able to adapt for your needs, If you want it I'll post it Good Luck