how do i copy the contents of a sheet into a Email.

Aug 21, 2013 at 4:30 PM
Is there a way i can copy the contents of a worksheet into a mail with HTML format and send it?

may be there is, if so please do help me.

Regards
Vinay.
Aug 29, 2013 at 3:23 PM
It's easy enough to send the generated worksheet as an attachment would this not work for you? I'm not sure what you mean by copy the contents into a mail with HTML format. Are you asking for it to be as if a user opened the spreadsheet, copied the contents to the clipboard, and then pasted it into an HTML email? I doubt that's a trivial task but I may be mistaken.
Aug 30, 2013 at 12:05 PM
Yes the attachment won't work, need a way to automate the contents of the excel sheet as html to a mai.body = sheet[0].getcontentasHTML():
mail.send():

This is what I am after. So the images graphics remain intact with formatting.

Kind regards
Vinay.