Hello SSChampion

thanks a for your answer , from your query i can get the id but mail was not received in my inbox

also it is not listed in select * from sysmail_allitems

at what position i can show that mailid which is return after execute sp_send_dbmail