MailApp.sendEmail 不工作? [英] MailApp.sendEmail Not Working?

问题描述

我在 Google Docs 电子表格中有几个脚本，它们使用 MailApp.sendEmail 发送包含电子表格数据的电子邮件.多年来，他们都出色地工作.大约 2 周前，他们停止发送电子邮件.脚本仍在运行，我没有收到任何错误.电子邮件永远不会通过.什么都没有改变，只是电子邮件不再到达.

I have several scripts in Google Docs spreadsheets that use MailApp.sendEmail to send e-mails incorporating data from the spreadsheets. They've all worked marvelously for years. About 2 weeks ago, they stopped sending the e-mails. The scripts still run and I don't get any errors. The e-mails just never come through. Nothing has changed, except that the e-mails aren't arriving anymore.

有什么想法吗?

谢谢！

推荐答案

我想我对自己的问题有了答案，这可能对遇到此问题的其他人有所帮助.MailApp.sendEmail 确实，确实，似乎仍然有效.发生变化的是 Gmail 处理某些类型邮件的方式.

I think I have an answer to my own question, which may be helpful to anybody else who has this problem. MailApp.sendEmail DOES, indeed, still seem to be working. What has changed is the way Gmail is handling certain types of messages.

如果我使用 MailApp.sendEmail 向第三方发送电子邮件，它会通过，没问题.正如 Fashtas 所指出的，如果我使用 MailApp.sendEmail 向电子表格所属的 Gmail 帐户发送电子邮件，没问题.

If I use MailApp.sendEmail to send an e-mail to a third party, it'll get through, no problem. As pointed out by Fashtas, if I use MailApp.sendEmail to send an e-mail to the Gmail account that the spreadsheet belongs to, no problem.

问题是:如果我使用 MailApp.sendEmail 将邮件发送到自动转发回电子表格所属的 Gmail 帐户的第三方帐户，这些邮件将不再通过.

Here's the problem: if I use MailApp.sendEmail to send the message to a third party account that automatically forwards BACK to the Gmail account that the spreadsheet belongs to, those messages no longer get through.

因此，在我上面发布的示例代码中，matt@.com 电子邮件地址会自动转发回我的 Gmail 帐户.MailApp.sendEmail 发送的邮件通过 .com 邮件服务器，但由于某种原因，它们没有转发回我的 Gmail 收件箱.它们出现在 Gmail 已发送邮件文件夹中(大概是因为它们是由电子表格所属的 Gmail 帐户发送的)，但它们从未进入收件箱.

Therefore, in the sample code I posted above, the matt@.com e-mail address automatically forwards back to my Gmail account. The messages sent by the MailApp.sendEmail make it through to the .com mail server, but for some reason, they don't get forwarded back to my Gmail inbox. They appear in the Gmail Sent Items folder (presumably because they were sent by the Gmail account that the spreadsheet belongs to), but they never hit the inbox.

这种行为是新的.过去，这些邮件从 *.com 服务器转发到我的 Gmail 收件箱没有问题.我不知道是什么改变导致了这个问题.我不知道如何解决它.

That behavior is new. In the past, there has been no problem with those messages getting forwarded from the *.com server to my Gmail inbox. I don't know what changed to cause the problem. And I don't know how to fix it.

因此，我认为我的问题的答案是 MailApp.sendEmail 按设计工作.

But I, therefore, think the answer to my question is that MailApp.sendEmail IS working as designed.

这篇关于MailApp.sendEmail 不工作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！