How to get text with formatting from Docs and use it for body to send email

Question

I'd like to send emails from spreadsheet using contents of google docs file for a message (E-mail body). This is what I have now, which works fine.

*Part of code

var doc = DocumentApp.openById(row[9]);
var message = doc.getText();

MailApp.sendEmail(emailAddress, subject, "Dear " + row[6] +"\n\n"+ message + "\n\n"+ row[1] + "\n" + row[2] + "\n" + row[3] + "\n" + row[4]);

It works perfectly fine but the e-mail message is plain text.

I have a little bit of formatting such as Blod/Colored/List format... and etc. How can I keep those formatting in e-mail message?

I tried getBody() or getParagraph(), but it only returned "Document" or "Paragraph, Paragraph, Paragraph".

*FYI
I tried this. How to send rich text emails with GmailApp? which worked okay, but I'm trying to find a solution to use rich text directly to email. Not work-around using html format.

score 3 · Answer 1 · answered Mar 31 '17 at 11:28

function test_mail_() {
 var id = DocumentApp.getActiveDocument().getId();
 var url = "https://docs.google.com/feeds/download/documents/export/Export?id=" + id + "&exportFormat=html";
 var param = {
    method: "get",
    headers: {
        "Authorization": "Bearer " + ScriptApp.getOAuthToken()
    },
    muteHttpExceptions: true,
 };
 var html = UrlFetchApp.fetch(url, param).getContentText();
 var raw = Utilities.base64EncodeWebSafe("Subject: Test\r\n" +
    "From: " + Session.getActiveUser().getEmail() + "\r\n" +
    "To: test@gmail.com\r\n" +
    "Content-Type: text/html; charset=UTF-8\r\n\r\n" +
    html + "\r\n\r\n");
 var message = Gmail.newMessage();
 message.raw = raw;
 var sentMsg = Gmail.Users.Messages.send(message, 'test@gmail.com');
}

This worked for me. hope this may help

How to get text with formatting from Docs and use it for body to send email

1 Answers1