Hi Lucky247, I am not an experienced programmer as well and had no clue about Java Script at all.
What I did to fulfill the reporting requirements of my time booking application is following this tutorial: https://developers.google.com/apps-script/articles/sending_emails?hl=de Based on this I could read out any Spreadsheet content and put it into an HTML file and then send out the required spreadsheet content as a HTML attachment (HTML table). I suggest to study the MailApp.sendEmail(emailAddress, subject, message); function in detail here: https://developers.google.com/apps-script/class_mailapp For populating the HTML table I made use of this template: https://docs.google.com/a/tfv-lac.org/previewtemplate?id=0AjbZnjlHMPF0dElqUnRCX1dHdWpXNUMtQTcwRGlmMVE&mode=public# Hope this helps. With best regards Heinz Am Sonntag, 4. März 2012 22:11:54 UTC+1 schrieb Lucky247: > > I found some code to download the files into pdfs which is what I > manually do for each sheet right now. > > http://code.google.com/apis/documents/docs/3.0/developers_guide_protocol.html#DownloadingSpreadsheets > > > Still not sure how to complete the entire project, but slowly I'm > piecing together bits and pieces. Any additional idea's are much > appreciated :) > > > > On Mar 3, 1:10 pm, Lucky247 <[email protected]> wrote: > > Thank you Giacomo and I appreciate the suggestion. It is just that > > creating a client tool is well beyond my programming capabilities > > currently. Are there any other idea's to do it? > > > > On Feb 29, 4:00 am, Giacomo Licciardello <[email protected]> > > wrote: > > > > > > > > > > > > > > > > > Hi Lucky247, > > > I had a similar problem for one of my client, in my case he simply > need to > > > process a single worksheet to different emails, so the only way to do > this > > > that I had found was to create a client tool (written in C#.Net) which > > > download and process the data from the worksheet then send by itself > to > > > whatever emails. > > > > > Cheers, > > > -- > > > * *Dott. Giacomo Licciardello > > > Analista Programmatore > > > http://www.gl-software.it > > > Cell. 3897907419 > > > Skype : skyline72 > > > > > 2012/2/29 Lucky247 <[email protected]> > > > > > > Hi Vic, > > > > > > Thank you for the reply. I followed your link and came across a > > > > related link (http://code.google.com/googleapps/appsscript/articles/ > > > > sending_emails.html#section1) where it shows a script is able to > send > > > > data in a cell directly to e-mail addresses. This is not too far > from > > > > what I need to do. I need to send 10 different tabs within my > > > > workbook to 10 different e-mail addresses. I'll give it some more > > > > thought, but any tips / hints / pointers / assistance would be very > > > > very very much appreciated. > > > > > > On Feb 28, 5:08 pm, Vic Fryzel <[email protected]> wrote: > > > > > Hi Michael, > > > > > > > At this time, there's no way to automatically export a worksheet > from a > > > > > spreadsheet straight to an email. This can be implemented using > > > > something > > > > > like Google Apps Script [1], but we don't expose this feature in > our UI. > > > > > > > [1]http://code.google.com/googleapps/appsscript/ > > > > > > > Thanks, > > > > > -Vic > > > > > > > On Mon, Feb 27, 2012 at 7:18 PM, Lucky247 <[email protected]> > wrote: > > > > > > Is this possible? Export spreadsheet tabs directly to gmail? I > think > > > > > > it should be doable? Am Sonntag, 4. März 2012 22:11:54 UTC+1 schrieb Lucky247: > > I found some code to download the files into pdfs which is what I > manually do for each sheet right now. > > http://code.google.com/apis/documents/docs/3.0/developers_guide_protocol.html#DownloadingSpreadsheets > > > Still not sure how to complete the entire project, but slowly I'm > piecing together bits and pieces. Any additional idea's are much > appreciated :) > > > > On Mar 3, 1:10 pm, Lucky247 <[email protected]> wrote: > > Thank you Giacomo and I appreciate the suggestion. It is just that > > creating a client tool is well beyond my programming capabilities > > currently. Are there any other idea's to do it? > > > > On Feb 29, 4:00 am, Giacomo Licciardello <[email protected]> > > wrote: > > > > > > > > > > > > > > > > > Hi Lucky247, > > > I had a similar problem for one of my client, in my case he simply > need to > > > process a single worksheet to different emails, so the only way to do > this > > > that I had found was to create a client tool (written in C#.Net) which > > > download and process the data from the worksheet then send by itself > to > > > whatever emails. > > > > > Cheers, > > > -- > > > * *Dott. Giacomo Licciardello > > > Analista Programmatore > > > http://www.gl-software.it > > > Cell. 3897907419 > > > Skype : skyline72 > > > > > 2012/2/29 Lucky247 <[email protected]> > > > > > > Hi Vic, > > > > > > Thank you for the reply. I followed your link and came across a > > > > related link (http://code.google.com/googleapps/appsscript/articles/ > > > > sending_emails.html#section1) where it shows a script is able to > send > > > > data in a cell directly to e-mail addresses. This is not too far > from > > > > what I need to do. I need to send 10 different tabs within my > > > > workbook to 10 different e-mail addresses. I'll give it some more > > > > thought, but any tips / hints / pointers / assistance would be very > > > > very very much appreciated. > > > > > > On Feb 28, 5:08 pm, Vic Fryzel <[email protected]> wrote: > > > > > Hi Michael, > > > > > > > At this time, there's no way to automatically export a worksheet > from a > > > > > spreadsheet straight to an email. This can be implemented using > > > > something > > > > > like Google Apps Script [1], but we don't expose this feature in > our UI. > > > > > > > [1]http://code.google.com/googleapps/appsscript/ > > > > > > > Thanks, > > > > > -Vic > > > > > > > On Mon, Feb 27, 2012 at 7:18 PM, Lucky247 <[email protected]> > wrote: > > > > > > Is this possible? Export spreadsheet tabs directly to gmail? I > think > > > > > > it should be doable? -- _______________________________________________________________ This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. -- _______________________________________________________________ This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
