Challenges with automating Data Explorer results

Probably?

I think that one query to view in data explorer and another for an email seems OK. Is your problem just that you need two queries?