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?
