I need to add tim@wekeycars.com
to the if(newPart[l][0] != 'kurt@metrolockdm.com')
so that both are excluded from the array generated by the for loop.
Correct me if I am wrong, but I thought I read somewhere that var can be used to to hold the 2 conditions, but I can't seem to make it work.
for(var l = 2; l<newPart.length;l++){
if(newPart[l][1] == 'New Item/Special Order'){
if(newPart[l][0] != 'kurt@metrolockdm.com'){
if(newPart[l][7] == ''){
dsmSO.push([newPart[l][0],newPart[l][6]])
var d = new Date();
control.getRange(l + 2,9).setValue(d)
}
}
}
}