Google Apps Script - Send Email from Sheets Custom HTML Template 1 Custom Font Email

[@chuckf5540]

Hi Laurence, Great tutorial - very clear and understandable. Everything work as advertised and I've learned a lot about object oriented programming. I did have an issue with htmlBody vs htmlbody but your trouble shooting techniques works great. Thanks again - I will continue this series with much excitement,

[@Amalshavahab]

Hi Laurence, It was really helpful and you explained from a layman's view which made it very easy to understand each and every line of syntax. But is there any way to keep a separate button to send the mail for all the mails together at one click?

[@Katsiarina1]

Love that, going to try it out at work 👍🏻

[@LaurenceSvekisCourses]

thanks for watching the video

[@boredomindex3353]

Hi Laurence, Thank you for the excellent tutorial. Btw, how do we add the email subject dynamically? Let's say I have an extra column with subject lines.

[@LaurenceSvekisCourses]

Its in the mailApp Service sendMail() you can also do it in the options as subject which provides more flexiblity.

[@c.nastassi]

Hi! Thanks very much for the video. I used the code and it works perfectly. I was wondering, what should I change in order to send all the emails at the same time? I guess it is something related to the getActiveCell but the truth is that I do not have a HTML background and I am not sure.

[@LaurenceSvekisCourses]

You can send lots of emails at once, keep in mind there are limits and the apps script server can time out on scripts that are running too many processes at once, this depends on the server load and will vary

[@hafsaadil7930]

Hey Lau, I want to inquire about the execution time run out for approver I have added all the codes as you’ve mentioned but still I’m getting this error ? Can you please explain

[@TheKirbyn]

Hi, I have an html template file and in the paragraph I need to add a variable that is defined in my google app script. How do I pick up that variable?

[@LaurenceSvekisCourses]

Use the scriptlet

[@thomasbihn]

A couple things I noticed - 1. Tools didn't have Script Editor, but did have Apps Script as a menu option. 2. Next to Debug is "No Functions" I didn't see how to get onOpen to test it without exiting the spreadsheet

[@LaurenceSvekisCourses]

The sheets changed its now under extensions, works the same way. The drop down of functions should be the same for run and debug.

[@HarpreetSingh-sm8vr]

btw if i want to send email only for last row or when there is new data in sheet,how can i send to that last row only .

[@calebmackey5529]

How did you popluate the "yes_no" button options, mine will not populate and when it is manually typed in it gets an error message.

[@LaurenceSvekisCourses]

Please refer to the source code at git

[@taylorpearson299]

Hi I am attempting to follow this video. I have done the code just like you have but when I try to run the script to send the email it does not send. I try to debug it and run in the apps script but there are no errors. What am I missing that it does not send the email? I am attempting to get it to send an email when someone marks something as approved in the spreadsheet.

[@LaurenceSvekisCourses]

do you throw any errors in the debugger?

[@PartTimeHero77]

Thank you for the video. I have a couple of questions for you. What if I wanted to also send an email for the "NO" answer? What if I wanted to send it from. The Gmail mail function without the HTML? Thank you again

[@LaurenceSvekisCourses]

Yes within the code you can send the email by applying a condition statement. You can send text based emails of HTML emails with MailApp class

[@ex3d]

Excellent content 11/10

[@LaurenceSvekisCourses]

thank you

[@dimitrisvoudouris]

I would like to ask if it is possible to send emails with the ability to select the sender, that is, I have 100 email addresses but I want to send to two specific ones

[@LaurenceSvekisCourses]

Yes you can customize the script to send to specific address from a list, use an array for the list and compare it to the full list if you want.

[@dimitrisvoudouris]

@@LaurenceSvekisCourses thank you very much

[@HarpreetSingh-sm8vr]

i want to send email only when there is new data in sheet,i mean to last row of data in sheets rather tha i dont want to start from begining to end. want to send only last row only. How can i do

[@NarenSushma]

'Exception: No HTML file named temp was found' is what I am getting when I run it. Could you pls help me out with this. Thanks.

[@LaurenceSvekisCourses]

You would need to create the file by that name to reference it within the code.

[@fakeaccount3415]

Do you know how to format time in html. It always shows as eastern time bla bla

[@LaurenceSvekisCourses]

It goes by the Google Account settings within the sheet.

[@EBahri]

How many mail can I send?

[@EBahri]

!!

[@EBahri]

and can i use it for email marketing , thank you sir

[@LaurenceSvekisCourses]

There are limits it depends on your Google Account. I wouldn't suggest it for a mass emailing as there could be blocks in place.

[@ehsan.1015]

When I press run it shows this: Exception: Cannot call SpreadsheetApp.getUi() from this context. onOpen @ Untitled 4.gs:2. Can someone help me out pls.

[@LaurenceSvekisCourses]

the ui is only with bound scripts not standalone. the error is that there is no ui available

[@thomasbihn]

@@LaurenceSvekisCourses How do you make it a bound script? There was no script editor menu for me when trying to follow allong, just Extensions - > App Scripts. Thanks