Bex Broadcaster- report via email

HI ,

I am trying to test the Bex broadcasting functionality executed a query through broadcaster and received the query results as an email.

how to set up the format for the queries to look good.

I tried to use as an independent HTML file.

Thanks

sampath