Hi All
I found script belove auto email with attachment from Gmail to recipient when Google Form submit
My quesion is How to change code Auto email from Outlookwhen Google Form submit (not by Gmail ).
Thanks.
I found script belove auto email with attachment from Gmail to recipient when Google Form submit
VBA Code:
function email() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName('OneClick');
var file = DriveApp.getFilesByName('OneClick_HU.xlsx').next()
var recipient = sheet.getRange(sheet.getLastRow(), 4).getValue() + ',' + sheet.getRange(sheet.getLastRow(), 5).getValue();
var subject = 'Hello, this is your Excel file';
var name = sheet.getRange(sheet.getLastRow(), 2).getValue();
var chinhanh = sheet.getRange(sheet.getLastRow(), 3).getValue();
var body = 'Hallo ' + name + ' - ' + chinhanh +', \r\n please download file';
MailApp.sendEmail(recipient, subject, body,{attachments: file});
}
My quesion is How to change code Auto email from Outlookwhen Google Form submit (not by Gmail ).
Thanks.