Of course, this example was just to make it simpler for you to understand the basic coding strategy when sending emails using App Script. Now whenever you need to send an email, you only need to click this button. Once this is done, you can simply click this image whenever you want to re-run your scriptĦ. Then insert the name of your scripted function, which in our case is sendEmail: Insert drawing of a button or any image of your choice into a corner of your sheet:Ĭlick on the button, select the three dots on the top right corner of it and select ‘ Assign Script’. Now, let’s add a button to automatically run our script. If you check the inbox of the recipient email address, you will find an email message from your Gmail account, with the subject and message that you had in your Google Sheet cells.ĥ.
#AUTOMATIC EMAIL SENDER FROM EXCEL CODE#
Once the message goes, your code is done running. That’s it, you will find a small message on top of your Script Editor screen saying that your script is running. When you get the confirmation, just click Allow. Click on Advanced, then scroll down and click ‘ Go to sendEmail’.Ĭ. Well, you’re the author, so you obviously don’t mind. You will then be given a warning that your App has not been recognized by Google and that you should proceed only if you know the author. When you run the code, you will be asked for permission to access your data on your Google sheet.ī. You can now run the code to see if there are any errors by pressing the button in the toolbar. We’re just going to go ahead and name it ‘ sendEmail’. Save your project by selecting File -> Save. Similarly, the value in the second row, the second column (B2) is assigned to the variable subject and the value in the second-row third column (C2) is assigned to the variable message.įinally, in line 6, we are using the ndEmail() function to send an email to the intended email address, with the subject and message contained in the respective variables.Ĥ. Using the Sheet1’s getRange() function, we are assigning the value that is in the second row, the first column (cell A2) to the variable emailAddress. In lines 3, 4, and 5, we are creating three variables – emailAddress, subject, and message. In the first two lines, we are getting access to the spreadsheet named ‘Sheet1’ and storing a handle to it in a variable called sheet1. Var message = sheet1.getRange(2,3).getValue() Var subject = sheet1.getRange(2,2).getValue() Var emailAddress = sheet1.getRange(2,1).getValue() Type the following lines within the curly braces: var ss = SpreadsheetApp.getActiveSpreadsheet() Inside the curly braces, we can define what this function is going to do. So, replace the word myFunction (which is the function name), with our new function name, sendEmail.ģ. You will find a template for a function already present. From the Tools menu, select Script EditorĢ. Here are the steps you need to follow if you want to use App Script to send an email to a designated address:ġ. Where emailAddress, subject, and message can be replaced by references to the respective cells. The syntax in App Script to send an email is just one line: ndEmail(emailAddress, subject, message)
So, let’s say you have a spreadsheet with just one email address in a cell, an email message in the next cell, and the subject in the third cell. Let us send an email message to just one person using App Script. Sending a Single Email Using App Script in Google Sheets
0 kommentar(er)
