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