CODEWITHSUNDEEP
google-apps-script
GGG
GGG

Reputation: 41

How to forward email to another address with sendEmail(to,replyTo, subject, body)

I appreciate if you could help.

I need to find all unread emails in my gmail [email protected] and send them all to [email protected] by using sendEmail(to,replyTo, subject, body) https://developers.google.com/apps-script/reference/mail/mail-app

I tried to write a script but unfortinately it does not want work. I hope you could help

function RespondEmail(e) {

//send response email
var threads = GmailApp.search("to:([email protected]) label:unread");
for (var i = 0; i < threads.length; i++) {
threads[i].sendEmail("[email protected]",
               "[email protected]",
               "TPS report status",
               "What is the status of those TPS reports?")}


// mark all as read
var threads = GmailApp.search("to:([email protected]) label:unread");
GmailApp.markThreadsRead(threads);
}

I also would be happy if you could advise me how I can change the subject of the ReplyTo email according to original email which I receive on [email protected]

Upvotes: 4

Views: 10896

Answers (1)

Antoine Colson
Antoine Colson

Reputation: 656

The problem in your script lies in the fact that sendEmail() belongs to the GmailApp Service, so it always needs to be called the following way:

GmailApp.sendEmail()

For your needs, it may be more appropriate to use the forward() method.

In the following example, I added a custom subject which you can edit and adapt to your needs.

function RespondEmail() {

  //send response email
  var threads = GmailApp.search("to:[email protected] is:unread");
  var subject = "";
  var msg = "";
  var c = 0; // will be used to count the messages in each thread
  var t = "";
  var attachment = "";
  var forwarded = "";

  for (var i = 0; i < 3 /*threads.length*/ ; i++) { 
    // I set 'i' to 3 so that you can test the function on your 3 most recent unread emails.
    // to use it on all your unread email, remove the 3 and remove the /* and */ signs.                   

    t = threads[i]; // I wanted to avoid repetition of "threads[i]" for the next 2 lines haha
    c = t.getMessageCount() - 1;
    msg = t.getMessages()[c];
    forwarded = msg.getBody(); // that is the body of the message we are forwarding.

    subject = msg.getSubject();
    attachment = msg.getAttachments();

    msg.forward("[email protected]", {
      replyTo: "[email protected]",
      subject: "TPS report status of [" + subject + "]", // customizes the subject
      htmlBody: "What is the status of those TPS reports below?<br><br>" //adds your message to the body
        +
        "<div style='text-align: center;'>---------- Forwarded message ----------</div><br>" + forwarded, //centers
      attachments: attachment
    });
    t.markRead(); // mark each forwarded thread as read, one by one

  }
}

Upvotes: 8

Related Questions