+ Reply to Thread
Results 1 to 3 of 3

Google sheets, auto email by script

  1. #1
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Google sheets, auto email by script

    Hey all is anyone able to help, i need a script to auto send emails to multi addresses based on if the a set row says "Send Email", it can be triggered by a timed event, i have made a sample google sheet plz help.

    https://docs.google.com/spreadsheets...it?usp=sharing

    Thanks Ditch

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,583

    Re: Google sheets, auto email by script

    This script might get you started.

    As it is this will run when the sheet is open, you could add some conditions in the onOpen function to have it only run on certain days - not sure if there are timed triggers.
    Please Login or Register  to view this content.
    PS You'll also have to adjust the subject/message - wasn't really sure what to use there so for the message I create a comma separated list from all the data in the row and took the subject from column A.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Google sheets, auto email by script

    i can set a trigger on the sheet it self, so i can make it call a script at a set time, it does not need to be scripted into the code itself, thanks for this i will have a look and see if i can get it working, thanks for fast reply.

    Also how would i go around picking for example row B F H to send that data in the email as appose to all of the row?

    Thanks Ditch
    Last edited by Ditch1983; 05-16-2017 at 08:16 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-20-2017, 08:34 PM
  2. Google Sheets Script not working
    By jsmity in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-02-2017, 11:36 AM
  3. google sheets button with script
    By tselek1985 in forum Excel General
    Replies: 1
    Last Post: 10-17-2016, 06:18 AM
  4. [SOLVED] Auto Fill Formula into New Rows/Columns [Google Sheets]
    By banyanman in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 05-03-2016, 03:24 PM
  5. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  6. Looking for a way to populate cells based off multiple conditions
    By joker5893 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2016, 12:32 PM
  7. Auto email script sends to many times?
    By gutchek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2014, 07:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1