Sure, please do so and let me know if you have any further questions. Heinz
2012/3/18 Lucky247 <[email protected]> > Thank you very much for taking the time to share that information with > me. I'll review and post back with additional questions if any. > > On Mar 18, 6:03 am, Heinz Ruffieux > <[email protected]> wrote: > > 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=0AjbZnjlHMPF... > > > > 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_proto. > .. > > > > > 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_proto. > .. > > > > > 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? > -- Heinz Ruffieux General Manager _____________________________ OnDemand Management GmbH Hintere Gasse 2 CH-3285 Galmiz Mobile: +41 79 353 62 23 Phone: +41 33 533 31 91 Skype: ruffieuxh Email: [email protected] Web: http://www.ondemandmanagement.net -- _______________________________________________________________ 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.
