select * from msdb.dbo.sysmail_sentitems
USE msdb GO DELETE FROM dbo.sysmail_sentitems WHERE [subject] LIKE '%abc%'-- Or any other filer criteria
USE msdb GO DELETE FROM dbo.sysmail_sentitems WHERE send_item between 'date1' and 'date2']
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)