Please help modify a Script by Google

[vill]

Hi, I'm trying to implement the email scheduler script as per:

https://developers.google.com/apps-s...sending_emails

can I please ask for help with a few modifications?

it currently is looking 100 rows down (changed from 2 in the original version)

the issue is that it returns an error related to MailApp.sendEmail(emailAddress, subject, message);

emails are being received but this error fires off because there are blank spaces in the Sheet UNDER the initial top 2 emails. Blank spaces below them are unavoidable because the data is always changing so 100 rows changed in a script is taking this into consideration.


MOD #1: a script is to ignore all blanks so no error message is returned. can it ignore even the spaces in between the contacts and still fire off properly?

MOD #2: is there a way to add SEND FROM NAME field? currently, it shows the email address


I'm not a coder, would greatly greatly appreciate the edits in the actual script which I'm pasting below. please?

a link to the actual files if needed is also below.

thanking you much in advance.

https://docs.google.com/spreadsheets...it?usp=sharing


/**
* Sends emails with data from the current spreadsheet.
*/
function sendEmails() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = 100; // Number of rows to process
// Fetch the range of cells A2:B3
var dataRange = sheet.getRange(startRow, 1, numRows, 3);
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (var i in data) {
var row = data[i];
var emailAddress = row[0]; // First column
var message = row[1]; // Second column
var subject = row[2]; // Third column
MailApp.sendEmail(emailAddress, subject, message);
}
}


-----

ERROR IMAGE

https://www.excelforum.com/attachmen...1&d=1626031113

[Haluk]

You can check if the e-mail address is empty or not and send the e-mail accordingly as shown in the below modified script;

Please Login or Register  to view this content.

[vill]

thank you, Haluk, greatly appreciated.

I actually had to hire someone to help with this, here's a script that also includes FROM NAME column:


/**
* Sends emails with data from the current spreadsheet.
*/
function sendEmails() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = 100; // Number of rows to process
// Fetch the range of cells A2:B3
var dataRange = sheet.getRange(startRow, 1, numRows, 4);
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (var i in data) {
var row = data[i];
var emailAddress = row[0]; // First column
var message = row[1]; // Second column
var subject = row[2]; // Third column
if (!emailAddress) {continue}
MailApp.sendEmail(emailAddress, subject, message, {name: row[3]});
}

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)