Issue with mail line break

[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.

[Tanaike]

About "Whenever I send mail using apps script the body of the mail breaks after every 80 characters and proceeds to a new line.", can you provide your current script for replicating your issue?

[Lokesh DS]

Hi Tanaike,

Here is the script im using.

function sendemail() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var sss = ss.getSheetByName("Todays's demo");

  var lr = sss.getLastRow();

  for (var i = 2 ; i <= lr ; i++){

    var emails1 = sss.getRange(i,8).getValue();

    if(emails1 != ""){

var emails = sss.getRange(i,8).getValue();

var parentname = sss.getRange(i,4).getValue();

var studentname = sss.getRange(i,5).getValue();

var subject = "Zoom Link for "+ studentname + "'s Class with Pepkidz";

Logger.log(subject)

var slotstarttime = sss.getRange(i,11).getValue();

var slotdate = sss.getRange(i,9).getValue();

var teachernme = sss.getRange(i,17).getValue();

var zoomlink = sss.getRange(i,19).getValue();

var template = ss.getSheetByName("Template");

var templatebody = template.getRange(1,1).getValue();

var info = {

Parent_Name : parentname,

Student : studentname,

Slot_Start_Time : slotstarttime,

Demo_Date : slotdate,

Teacher_Name : teachernme,

Zoom_Link : zoomlink

}

var emailtext = templatebody.replace("{{Parent name}}",parentname).replace("{{Student}}",studentname).replace("{{Slot Start Time}}",slotstarttime).replace("{{Demo Date}}",slotdate).replace("{{Teacher Name}}",teachernme).replace("{{Zoom Link}}",zoomlink).replace("{{Student}}",studentname) ;

Logger.log(emailtext)

MailApp.sendEmail({to : emails, subject : subject, body :emailtext })

  }}

  Browser.msgBox("Email's Sent")

}

On Wed, 2 Feb 2022 at 07:32, Tanaike <kanshi...@gmail.com> wrote:

About "Whenever I send mail using apps script the body of the mail breaks after every 80 characters and proceeds to a new line.", can you provide your current script for replicating your issue?

--
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/92b8b22d-c73c-466e-a018-794322159118n%40googlegroups.com.

--

Regards,

Lokesh

[Tanaike]

Thank you for replying. When I tested a text over 80 characters (without using the line break) to the text body of "MailApp.sendEmail" and retrieved the email, no line break is included in the email body. So, unfortunately, I cannot replicate your situation. I apologize for this. In order to correctly replicate your situation, can I ask you about the detailed flow for replicating your issue? By this, I would like to confirm it.

[Clark Lind]

This is only a hunch, but if you have "word wrap" turned on for Template cell A1, that may be adding the line feed. Try turning Word wrap off and see if that clears the problem.

[Lokesh DS]

Hi Clark,

Thanks for response.

I tried wrapping still the issue not resolved.

--

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/09331b13-c984-43c6-9ebf-73f785bad6dcn%40googlegroups.com.

--

Regards,

Lokesh

[Braja Patnaik]

You can solve it by using GmailApp.sendEmail(emails, subject, emailtext), instead of MailApp.sendEmail

[Lokesh DS]

Hi Braja Patnaik,

Thanks for the suggestion it worked,

Thanks, everyone for your help.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/6c423416-2e09-4e3f-bec6-dc2e72eebbfen%40googlegroups.com.

--

Regards,

Lokesh

[Nikhil Chitmulwar]

This one worked.

Thank you so much.