You can set up a job in SQL to run every night and when X date = server date have SQL send an email out to whom ever. That would be the easiest way to do it.
--Stole this from a moderator
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.