Well, I store emails in SQL Server, but I don't use xp_sendmail. I have written a small app in VB, added references to ADO and CDO, and that's it.
Basically the same question on storing newsgroup posts I asked a while ago, because I didn't know how to access posts via NNTP. But as I can't access newsgroups while at work, I didn't follow that way any further.