CQLBoy,

Thanks for your post, it solved my issue. I posted your solution as a work around on microsoft connect site.

https://connect.microsoft.com/SQLServer/feedback/details/361954/sp-send-dbmail-fails-when-query-parameter-and-ole-automation-is-used-in-same-batch?wa=wsignin1.0#

Thanks,

Srini