Mail through sql server 2000

I have the table "Customer"

开发者_运维技巧

It contains the fields - CustomerID,Email and ExpiryDate.

eg:

CustomerID         Email               ExpiryDate

1                  aji@gmail.com       19/11/2010

2                  john@yahoo.com      18/11/2010 

3                  Joseph@gmail.com    19/11/2010

I have to send an alert mail to all customers email ids whose expirydate is today.

How can I do it in sql 2000?

---

Install Sql Mail: https://web.archive.org/web/1/http://blogs.techrepublic%2ecom%2ecom/datacenter/?p=363

---

• SQL mail, requires a MAPI client, uses xp_sendmail
• Use the extended stored proc xp_smtp_sendmail for SMTP (not sure if supported now, YMMV)
• Last resort: use sp_OA% and cdosys

Or upgrade