Thanks Sergey

>Something like
>

>-- Stop DBmail from sending messages
>EXEC msdb..sysmail_stop_sp
>
>...
>
>-- Get list of all or unsent messages
>SELECT * FROM msdb..sysmail_allitems
>SELECT * FROM msdb..sysmail_unsentitems
>
>-- Delete messages
>EXEC sysmail_delete_mailitems_sp  @sent_status = 'unsent'
>...
>

>
>
>>
>>I'm using msdb.dbo.sp_send_dbmail to send some emails out from my database.
>>
>>I've tested all of my routine but the last step where the correct outgoing email addresses are used. I've been routing all the email to myself.
>>
>>How can I run the routine with the live emails addresses but not actually send them (I guess I want the outgoing mail to be queued in some way so I can check the email allocation.)
>>
>>Thanks
>>
>>Nick