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

[@tariknavarro87]

Thank you very much!!

[@LaurenceSvekisCourses]

You're welcome!

[@astorgadexterpelaez3502]

thank you Mr. Laur

[@sankareganthan4383]

Thanks Laurence, your videos are very helpful to me to learn about the app script. Can you make a video, how to send message from google sheet to g-chat using app script

[@LaurenceSvekisCourses]

Great suggestion!

[@PartTimeHero77]

Great job

[@LaurenceSvekisCourses]

Thanks for watching

[@brittanm.s.breaux2595]

Laurence, on line 30:
Why do you set ' temp.user = user; '?

[@LaurenceSvekisCourses]

to add it in the object format

[@LaurenceSvekisCourses]

the object is global

[@kimysanchez2931]

Is it possible to schedule the emails?

[@sound_now9036]

hi Laurence ,very helpful thanks. Can you do a video on how to send automatically when a row is appended each time? Would be really helpful, thanks

[@LaurenceSvekisCourses]

Great suggestion! I do have some videos on that adding it can be done with a trigger

[@sound_now9036]

@@LaurenceSvekisCourses great I'll check your other videos. Another question - is there a way to track email link click responses in the google sheet? I want to track responses of a consent (newsletter confirmation). The script sends out the autoresponder email, but I will need to track who actually clicked on the link / landing page in the email.

[@AldenGaffud]

Thanks Laurence! This two part tutorial is very helpful. I am not very good at this and just followed every step and rearrange my columns based on your example. Here's my questions. Each row will send an email to the email address in column C. What if I wanted to add two or more recipients? How do I do these? I tried creating columns for additional recipients but I don't really know how to edit the script. Hope you can help. :) Thanks in advance.

[@LaurenceSvekisCourses]

Glad it was helpful! You can comma separate the email addresses this will also work in the cc property
function sendEmails() {
var message = "Test Message";
var emails1 = "[e-mail]" + "," + "[e-mail]";
var emails2 = "[e-mail]";
var Subject = "Request";
var html = message;
MailApp.sendEmail({
to: emails1
cc: emails2
subject: Subject,
htmlBody: html
});
}

[@RahulKumar-sk5st]

I want to know how to send reminder on same bulk mail which one send through macro

[@LaurenceSvekisCourses]

yes you can send emails with apps script

[@israelrivera4467]

Hey everyone, can someone tell me how I form a scriplet: . Is it in the Appscript code, HTML or withing scriplet? I already tried some thing, did not work. Thank you for your help.

[@LaurenceSvekisCourses]

Yes you do the scriplet with the tags is to run the script include the = to output the results. Include the for response value

[@israelrivera4467]

@@LaurenceSvekisCourses
Thank you very much for your answer, Im sorry I did not explain my question correctly. I mean If want to format the content within the scriplets as date for example, where and how I do that? for example I get the date from spreadsheet bu I get 11/1/2022 Central Time 00:00, but I just need as It is in on the spreadsheet, just: 11/1/2022

[@naveenofficial8754]

In the email body I need to be send table how?

[@LaurenceSvekisCourses]

You can make an HTML table and send it that way

[@naveenofficial8754]

Error: cannot read property 'first' of undefined

[@LaurenceSvekisCourses]

the object is not correctly selected

[@rocxione]

how to send for all email, not 1 by 1

[@LaurenceSvekisCourses]

each request will send an email, you can run it in a loop

[@rocxione]

@@LaurenceSvekisCourses How to do this? I'm not very good with google sheets and Apps Script, is there a video explaining how to send email with just one tap?