I had to tweak it a little for it to work for me. I had to add the @profile_name for my sp_send_dbmail to work.

I have the stored procedure saved...