Emailer.gs

 /* Registration confirmation Email from submitted Google Form */ 
 function Initialize() { 
	var triggers = ScriptApp.getScriptTriggers(); 
	for (var i in triggers) {
		ScriptApp.deleteTrigger(triggers[i]);
	} 
 ScriptApp.newTrigger("SendConfirmationMail")
 .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
 .onFormSubmit()
 .create(); 
 } 
 function SendConfirmationMail(e) { 
	try { 
		var ss, bcc, sendername, subject, columns;
		var message, value, textbody, sender;
		var location, time; 
		// This is your email address and you will be in the BCC
		bcc = Session.getActiveUser().getEmail(); 
		// This will show up as the sender's name
		sendername = "UPDATE WITH YOUR NAME"; 
		// WHERE AND WHEN THE EVENT IS!!!
		location = "The EVENT will take place at:
LOCATION INFORMATION

"; time = "DATE, starting at START TIME and ending about END TIME
"; // Optional but change the following variable // to have a custom subject for Google Docs emails subject = "Registration Successful"; // This is the body of the auto-reply message = "Thank you for your event registration.

"; message += location; message += time; ss = SpreadsheetApp.getActiveSheet(); columns = ss.getRange(1, 1, 1, ss.getLastColumn()).getValues()[0]; // This is the submitter's email address sender = e.namedValues["Email"].toString(); // Only include form values that are not blank for ( var keys in columns ) { var key = columns[keys]; if ( e.namedValues[key] && e.namedValues[key] != "" ) { message += key + ' : '+ e.namedValues[key] + "
"; } } textbody = message.replace("
", "\n"); GmailApp.sendEmail(sender, subject, textbody, {bcc: bcc, name: sendername, htmlBody: message}); } catch (e) { Logger.log(e.toString()); } }

Leave a comment