How to send multiple emails using google spreadsheet

sending emails by using Goole Spreadsheet is one of the best and time saving way to send multiple contacts .suppose i have to invite 20 members on my birthday.I may go to gmail and type the email one by one and send to them, or i can seperate them by a comma but what if i have to send invitation to them in next week agin to my sister birthday , there this idea works and saves you time 1.go to drive.google.com
login to your google drive if you dont have that then link up with your goole account .
2.Click on new and select goole sheets .you will see a new tab is opened named "Untitled spreadsheet"
3.Give a name to your sheet by clicking on"Untitled spreadsheet" top left of the page.
4.Fill 1st row 1st column by Email and 1st column 2nd row by Message.
5.Type all the emails as per requirement in email column and messages in next messages column .
6.Go to Tools->Script Editor .(a new tab will open with a pop op window "Google Apps Script" .
7.Click on Blank project . you will get the page with an editor .Replace "Untitled project" with any name and delete default code.
8.copy the code mentioned below and paste in the editor.
function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = 2; // Number of rows to process // Fetch the range of cells A2:B3 var dataRange = sheet.getRange(startRow, 1, numRows, 2) // Fetch values for each row in the Range. var data = dataRange.getValues(); for (i in data) { var row = data[i]; var emailAddress = row[0]; // First column var message = row[1]; // Second column var subject = "Sending emails from a Spreadsheet"; MailApp.sendEmail(emailAddress, subject, message); } } for a moment if you are not clear by above video have a look at the video mentioned below .