Chris already posted most of what I would have said with querying the mail system tables.  The only thing I'll add is how to check to see if the mail system is running.

EXECUTE msdb.dbo.sysmail_help_status_sp;

If the configuration Database Mail XPs isn't enabled, you won't be able to execute this procedure because it'll be blocked.