xp_readmail insert into a table

[voxinforma]

I am trying to get the output of xp_sendmail into a table. I've had limited success looping through xp_findnextmsg for the message_id, but what I really want is a full dump of xp_sendmail output inserted into a table.

Tried using the info in BOL to set up the table but haven't gotten it to work. unless xp_sendmail is doing something slinky that i havent learned yet, all i need is a proper table definition.

create table mymailstuff
(...table definition here)
insert into mymailstuff
exec xp_sendmail


Any help would be wonderful. thanks!

 

[vongrunt]

Er... xp_sendmail or xp_readmail?

 

[voxinforma]

sorry, i'm xp'd out this afternoon. i mean xp_readmail.