Xpsendmail And Table Not Found

I have a DTS package that has two steps. The first steps executes a sql statement that selects data into a temporary table. The next step emails the results of a "select * from #mytable" to me. I ran the job today and did not get an email from it. So, I then copied both statements to Query Analyzer and ran them in the same window. The SELECT query ran fine but the xpsendmail part gave me an error that #mytable does not exist.

This is my query

drop table #update_status
select col1,col2,col3
into #update_status
from mydb.mytable

go

EXEC master..xp_sendmail
@recipients = 'fkearney',
@query = 'select * from #update_status',
@subject = 'status updated',
@message = 'These records had a status update:',
@attach_results = 'TRUE', @width = 250

Any thoughts?