Yes you do. More specifically, you need MS Outlook 2000.
Originally Posted by just4me4
Try this link. Bear in mind that SQL Agent Mail and SQL Mail are different, and must be configured separately (though you don't have to configure both).
In general, I HATE SQL Agent Mail. If Outlook hangs or whatever reason, you can potentially hang your entire job scheduling process. It can get real ugly real fast.
Google SMTP solutions for SQL 2000 and you'll find a lot of other options. Best bet, though, is to go with SQL 2005 and use the new database mail feature (which is SMTP based).
Have you hugged your backup today?