Delete emails from outbox

[bharath3014]

I want to delete emails from the email log from outbox. Not all the mails, only from outbox i want to delete. Can anyone help me out with the background script to delete the emails from the log.

Thank you very much in advance.

[Prashant Sharm7]

Table is not sys_email_list, rather main table is "sys_email" only. So data should be deleted from table sys_email.

[Venkateswarlu K]

HI Bharath

can u pls follow the below figure

i hope this will helpful to u

[bharath3014]

Hi Venkat,

Thank you for your reply. That i can do for 20, 30 records. But in outbox there are morethan 25000 records, i want to delete all the mails from outbox. can you please help me in that.

[Venkateswarlu K]

u can use this Bharath

using the back ground script

var gr = new GlideRecord('sys_email');

gr.addEncodedQuery('mailbox=outbox');

gr.setLimit('2500');

gr.query();

while(gr.next()){

gr.deleteMultiple();

gs.log('email deleted');

gr.update();

}

[Anurag Tripathi]

You wont need gr.update(); or the while loop if you are using deleteMultiple()