Sending email script

[am90]

Hi Everyone,

I'm trying to send an email using a send button which I have got working fine but I'm trying to insert part of my sheet table into the email but I'm now a bit lost.

I've created an example of what i'm trying to do here https://docs.google.com/spreadsheets/d/18NQ4HjO31LiW5quQSSjXYrpj-7SqCaZHyf9j_XaLCmY/edit#gid=1232101730 there is a tab called emailExample and a script to go with it. The sending of the email is fine, the subject information and first part of the message work as expected but now I need to insert cells C3:F26 in the email as well. Please can anyone help with how to go about this?

I've done a mock screenshot of how I mean the final email it to look for reference.

Any help would be greatly appreciated.

Many Thanks

Note: The blank rows can be removed if that is possible I just want the ability to show all 26 if they are populated and the first column of emails is just there for later as I want this to be the source of emails the message gets sent to rather than a static email in the script but I haven't figured that out yet. I just put a temp email in the script as well for testing purposes.

[Mike Adler]

You basically needs to set up your email using HTML for the table.  Below is a guide to “cheat” using gmail if you don’t know how to build and html table.  Hope it helps...

https://spreadsheet.dev/send-html-email-from-google-sheets

---

From: google-apps-sc...@googlegroups.com <google-apps-sc...@googlegroups.com> on behalf of am90 <aaronja...@gmail.com>
Sent: Friday, August 28, 2020 3:44:13 AM
To: Google Apps Script Community <google-apps-sc...@googlegroups.com>
Subject: [Apps-Script] Sending email script

 

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/82f36083-d3f0-40a6-8ff1-a4cf2b42ac00o%40googlegroups.com.

[am90]

Hi, Thanks for sending that, I'll have a read through and see what I can come up with.

To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.