am also similar kind of requirement that I want to send the grid data on mashup to e-mail. how could I send and in what format we can send .
Just use MailServer extension and send an email, body parameter of SendMessage on MailServer it's HTML, just write and old fashioned HTML Table <Table><TR>... and you go.
Could you Please reply on this, Mark it as accept as solution if answer was helpful. So that other community user can take benefit of this.