Automatic Email Reminder

how to make email reminder if I have the expired date, for example 2014-01-07, and it will automatically send the email for reminding the user that their service will be expired in :

  1. 1 month before 2014-01-07 (so the email will be send in 2013-12-07)

  2. 2 weeks before 2014-01-07 (so the email will be send in 2 weeks before 2014-01-07)

  3. 7 days before 2014-01-07 (so the email will be send in 7 days before 2014-01-07)

please help. thanks :)

Hi,

Do you got any idea????

Build it as a console command and run it periodicly by crontab.