Advertisement
Guest User

Secret Santa Email Code

a guest
Nov 27th, 2014
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*
  2. * Send emails to people for secret santa. Assumes data is already shuffled.
  3. */
  4. function sendEmails() {
  5.   var sheet = SpreadsheetApp.getActiveSheet();
  6.   // B = name of person
  7.   // C = email of person
  8.   // D = name of assigned person
  9.   // F = things they like
  10.   // G = things they don't like
  11.   var startRow = 2;  // first row of data to process
  12.   var numRows = 29;   // number of rows to process (last row - start row)
  13.  
  14.   // fetch the range of cells B2:G30
  15.   var dataRange = sheet.getRange(startRow, 2, numRows, 7)
  16.   // fetch values for each row in the Range.
  17.   var data = dataRange.getValues();
  18.  
  19.   for (i in data) {
  20.     var row = data[i];
  21.     var name = row[0]; // B (0 because we didn't include A)
  22.     var email = row[1]; // C
  23.     var assignedName = row[2]; // D
  24.     var like = row[4]; // F
  25.     var dislike = row[5]; // G
  26.     var subject = "Secret Santa assignment!";
  27.     var message = "You've been assigned " + assignedName +
  28.                   ".\n\nThey like:\n"+ like +
  29.                   "\n\nAnd dislike:\n"+ dislike +
  30.                   "\n\nGifts tend to be ~$15 but feel free to go wild! " +
  31.                   "Please include 3 hints as to who you are (in the packaging or note or whatnot). " +
  32.                   "Gifts will be exchanged during the Winter Banquet (12/9)." +
  33.                   "\n\nHave fun!\n <3 Your social chairs";
  34.     MailApp.sendEmail(email, subject, message);
  35.     Logger.log("Sent email to " + name);
  36.   }
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement