sp_send_dbmail fails when mailing queries, but no error returned, query just hangs
Is it possible that you're running on a deadlock situation? Create a test table that you know for sure no one is accessing it, populate it with some sample data, and run a query in proc against that table just to test it out.