TypeError: ss.getSheetByname is not a function

[Adrien Blanchot]

Helllo here.

I have one script for Mailsending autmatic

But i have one error.

function myFunction() {

  // définir les variables

  var ss = SpreadsheetApp.getActiveSpreadsheet()

  var sheet1=ss .getSheetByname('Commandes');

  var emailaddress = sheet1.getrange(5,6).getValue();

  var subject = sheet1.getrange(5,7).getValue();

  var message = sheet1.getrange(5,8).getValue();

  // Envoyer le mail

  MailApp.sendEmail(emailaddress,subject,message)

21:20:25

Erreur

TypeError: ss.getSheetByname is not a function

myFunction

@ Sans titre.gs:4

Need Help pls

[Alan Wells]

Try using a capital letter "N" for Name.

getSheetByName

I'm guessing that's the problem.

[Adrien Blanchot]

Yeah ! It's that ! Thanks You ! 
 But I will have another request ^^

I just discovered the scripts.

And I try to automate the mail sending.

How can I do to send a mail for each line? 

[Flores Pablo Maria Sanguinetti]

Hi Adrien Blanchot  ;

For  sent mail ,you need declarate Const and Var of each row .Later declarate the cycle for to send the mail for row.

If you need help ,talk me .I develop un send mail for row and for all rows .

See you  

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/99166e82-a874-428b-9080-b3a65937c506n%40googlegroups.com.

[Adrien Blanchot]

Hello,

Thank you for your answer.

I would be very interested in your system

Flores Pablo Mari Sanguinetti

[Lokesh DS]

Hi,

I have a doubt please help me out here.

Whenever I send mail using apps script the body of the mail breaks after every 80 characters and proceeds to a new line.

Please help me how to avoid the auto line break here.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAByjscFyMU8ovO61G-FDViddiQG1ctjgr4zwAaa8kMqcHqnuqg%40mail.gmail.com.

--

Regards,

Lokesh