我可以使用google工作表中填充的新邮件窗口打开gmail吗？(Can I open gmail with a populated new message window from google sh

我可以使用google工作表中填充的新邮件窗口打开gmail吗？(Can I open gmail with a populated new message window from google sheets?)

我有一个包含电子邮件地址列表的Google电子表格。 这是各种联系人列表。 我想有一个功能打开一个gmail新邮件消息窗口与这些地址（或其中的一些子集），以便我可以完成电子邮件并发送。

Google Developers上的“ 发送电子邮件”教程向您展示了如何直接创建和发送电子邮件，而不是如何打开gmail以供进一步编辑。

看了MailApp的参考资料后，似乎我只能用它来发送已完成的电子邮件，而GMailApp似乎允许我访问现有的gmail消息。

有没有办法我可以用新的消息窗口启动gmail而不发送它？

I have a google spreadsheet that contains a list of email addresses. It's a contact list of sorts. I would like to have a function that opens a gmail new mail message window with these adresses (or some sub-set of them) so I can then complete the email and send.

The Sending Email tutorial on Google Developers shows you how to create and send emails directly, but not how open gmail ready for further editing.

Having looked at the reference for MailApp it seems that I can only use it to send completed emails, while GMailApp seems to allow me to access existing gmail messages.

Is there a way I can start gmail with a new message window without sending it?

最满意答案

Google Apps脚本无法与GMail用户界面进行交互。

另一种方法是生成mailto:链接，其中包含预填充的消息URL ，并在电子表格的对话框或侧边栏中将其呈现给用户。 单击链接时，应该打开一个新的消息窗口。

There is no way for Google Apps Script to interact with the GMail User Interface.

An alternative would be to produce a mailto: link with a prefilled message URL, and present that to the user in a dialog or sidebar in your spreadsheet. When the link is clicked, it should open a new message window.