Sending automatic alert email via sql server

Question

Hi all members,
Howdo i make sql server sends  automatically alert email to admin  when for example( expire_date > 10/15/2010)

any help would be so much appreciated
Best Regards.