Can a stored procedure in SS2K send an email?

I understand how to make a stored procedure (aka SP), but how would i get the SP to send an email? All the examples i've seen around here don't do anything like that.

If it can't, how could i get the SP to return the recordset object that the SQL statement creates to VB? That SQL statement will contain all the records/info i want/need in order to create the email.