"(And I must have done something a little while ago about setting up an
MAPI client like Outlook.) Now, when I go to Enterprise Manager, under
Support Services/SQL MAIL,
I have a MAPI profile and test to success. However, however, however,
when I attempted to run some sql extended procs for mail function like
xp_startmail, xp_sendmail, xp_stopmail I ran into errors, err msgs
include "failed with mail error 0x80004005". Searching for this err
msg has not generated interesting enough info. "

Are you logging in as the account under which the SQL Server service is
running? Be sure that you have a mail profile set up for that account,
and that profile is the one being used in SQL Mail.