Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. var body = "Hi "+ recipient+", <p></p> You have a new research request, submitted by "+FormattedFirstName+" "+FormattedLastName+". Study details are listed below."";
  2. if (emailSent != EMAIL_SENT) {
  3. if (StudyType === "ScenarioA") {
  4. var emailsubject = ("New " + StudyType + " Study Request");
  5. var recipient = "Sabrina";
  6. MailApp.sendEmail({
  7. to: "sabrina@gmail.com",
  8. subject: emailsubject,
  9. htmlBody: body
  10. });
  11. sheet.getRange(startRow + i, 23).setValue(EMAIL_SENT);
  12. }
  13. else if (StudyType === ScenarioB") {
  14. var recipient = "Salem";
  15. var emailsubject = ("New " + StudyType + " Study Request");
  16. MailApp.sendEmail({
  17. to: "salem@gmail.com",
  18. subject: emailsubject,
  19. htmlBody: body
  20. });
  21. sheet.getRange(startRow + i, 23).setValue(EMAIL_SENT);
  22. }
  23. else if (StudyType === "ScenarioC) {
  24. var recipient = "Zelda";
  25. var emailsubject = ("New " + StudyType + " Study Request");
  26. MailApp.sendEmail({
  27. to: "zelda@gmail.com",
  28. subject: emailsubject,
  29. htmlBody: body
  30. });
  31. sheet.getRange(startRow + i, 23).setValue(EMAIL_SENT);
  32. }
  33. }
  34. }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement