I used SQL Mail at my last employer. We had to install Outlook on the server and setup a mail profile. For the most part, it was reliable. we did have a few occasions where we had to restart SQL because mail hung, but that was fairly infrequent.

If you can upgrade to SQL Server 2005, using Database Mail is much easier.

😎