当您想要向客户、客户、员工、俱乐部成员或类似群组发送同一封电子邮件时，您可以输入一封电子邮件并使用 Gmail 邮件合并工具向所有人发送消息(Gmail)。
Gmail中的邮件合并曾经被称为“多重发送”功能，可让您插入Google 通讯录或(Google Contacts)Google 表格(Google Sheets)中的邮件列表。然后，使用合并标签个性化您的电子邮件，包括独特的取消订阅链接，并使用您最喜欢的电子邮件应用程序享受简单的批量电子邮件流程。
关于 Gmail 中的邮件合并
让我们看一下Google帐户要求、发送限制以及有关Gmail中邮件合并的其他详细信息。
- 邮件(Mail)合并功能可供Google Workspace订阅者使用，包括Workspace 个人版(Workspace Individual)、商务标准版(Business Standard)和增强版(Plus)、企业入门版(Enterprise Starter)、标准版(Standard)和增强版(Plus)以及教育标准版(Education Standard)和增强版(Plus)。
- 受支持的Google Workspace帐号每日发送电子邮件的上限为 2,000 封。通过邮件合并，您最多可以向 1,500 个收件人发送电子邮件，这样您就剩下 500 个收件人可以发送其他电子邮件。
- 使用邮件合并只能将一名收件人添加到抄送或密件抄送字段(CC or BCC field)。请(Just)记住，这将向“收件人”字段中每个收件人的地址发送一封电子邮件。例如，如果您向 100 个收件人发送邮件合并，则抄送字段中的地址会收到该电子邮件的 100 份副本。
- 您可以使用邮件合并包含附件；但是，这会会计入您的存储空间。例如，如果您向 100 个收件人发送一个 1MB 的附件，您将使用 100MB 的空间。
- 每封邮件底部都
包含一个自动生成的唯一取消订阅链接，以防特定收件人不再希望收到您的电子邮件。(Unsubscribe)
- 如果收件人之前已取消订阅您的邮件，并且您将其包含在邮件合并中，则在发送电子邮件后您会看到一条通知，其中包含不会收到该邮件的收件人数量。
- 您不能使用邮件合并进行回复或转发，或者在安排电子邮件(schedule emails)或使用机密模式(confidential mode)时。
如何将收件人添加到Gmail邮件(Gmail)合并(Mail Merge)
虽然您可以在撰写邮件后选择电子邮件的收件人(select the recipients for your email)，但最好在使用邮件合并时提前选择它们。然后，系统会提示您使用可用的合并标签来个性化消息。
添加来自(Add)Google通讯录
的收件人
要开始使用您的Google 通讯录(Contacts)作为收件人，请按照以下步骤操作。
- 选择(Choose Compose)左上角的“撰写”以创建新电子邮件。如果您没有看到Compose ，请使用显示(Show)主菜单图标（三行） 。
- 在“撰写”(Compose)窗口中，选择“收件人”字段最右侧的“使用邮件合并”图标（联系人符号），然后选中(Use)“邮件合并”(Mail Merge)框。
- 然后，您可以开始输入收件人姓名并从建议中选择他们，或者选择“收件人”链接并从“选择联系人”(Select Contacts)窗口中选择收件人。
从 Google 表格添加收件人
要从Google 表格(Google Sheets)插入收件人，首先要确保工作表设置正确。
- 所有收件人信息必须位于电子表格的第一个选项卡上。
- 每个收件人及其详细信息必须位于单独的行中。
- 使用(Use)纯文本列标题来指定合并标签。如果标题包含特殊字符，则合并标记将由列字母来标识，例如，@A 表示 A 列。
如果您的工作表已准备就绪，请选择Gmail左上角的“撰写”(Compose)来创建邮件。
- 选择“收件人”字段最右侧的“使用邮件合并”图标，然后选中(Use)“邮件合并”(Mail Merge)框。然后，选择从电子表格
添加。(Add)
- 在出现的窗口中，使用顶部的Google Drive选项卡找到并选择Google Sheet。然后，选择右下角的
“插入”按钮。(Insert)
- 在随后的窗口中，使用下拉框选择包含合并标签的收件人详细信息的列名称。请注意，您可能只会看到“电子邮件”(Email)、“名字(First Name)”和“姓氏”的下拉框；但是，您将在电子邮件中看到工作表中其他详细信息的合并标签。
- 选择“完成”(Finish)，您将返回“撰写”(Compose)窗口，“收件人”字段中将显示工作表的名称。
提示：如果您的收件人列表采用Excel 格式(Excel)，请查看将 Excel 文件转换为 Google 表格(ways to convert the Excel file to Google Sheets)以进行邮件合并的方法。
如何在电子邮件中使用(Your Email)合并标签(Merge Tags)
将收件人添加到邮件合并后，您将可以使用合并标签。
截至撰写本文时：
- 如果您从Google 通讯录(Google Contacts)添加收件人，则可以使用名字、姓氏或全名以及电子邮件地址的标签。
- 如果您从Google 表格(Google Sheets)添加收件人，则可以对电子表格中的列标题使用标签。
添加合并标签
要将标签添加到您的电子邮件，请键入 @ (At) 符号和标签名称，或从显示的下拉列表中选择标签。
您可以将标签添加到邮件中除电子邮件主题行和超链接文本之外的大多数位置。
预览合并标签
如果您好奇插入合并标签后详细信息如何显示，您可以轻松查看预览。
- 将鼠标(Hover)悬停在消息中的合并标签上，然后选择“预览”(Preview)。
- 然后，您将看到一个窗口，其中显示每个收件人及其该标签的相应详细信息。如果您有很多收件人，您可以使用顶部的搜索来查找他们。
- (Select OK)完成后选择“确定” ，您将返回“撰写”(Compose)窗口。
包括合并标签(Merge Tag)的默认值(Default Value)
您还可以为合并标签设置默认值。如果收件人缺少您尝试添加的详细信息，这会很有帮助。例如，如果您插入名字(First Name)合并标签，而收件人没有列出名字，则您可以改用默认单词或短语。
要添加默认值，请将鼠标悬停在电子邮件中的合并标签上，然后选择设置(Set)默认值。
在出现的框中添加单词或短语，然后选择“保存”(Save)。
对于任何缺少信息的收件人，电子邮件中的合并标签将替换为默认值。
预览并发送您的电子邮件
当您在Gmail(Gmail)中创建邮件合并后，您将能够在发送之前预览电子邮件。这使您可以像收件人一样查看电子邮件，因此如果您需要进行任何更改，可以在点击“发送”(Send)按钮之前进行更改。
- 准备好后，选择“撰写”(Compose)窗口底部的“继续”(Continue)。
- 发送群发电子邮件时，您会看到一条弹出消息，其中包含有关垃圾邮件的简要详细信息。选择“了解(Select Learn)更多”以获取更多信息，然后选择“知道了”以继续。
- 接下来，您将看到另一个弹出窗口，显示您要向其发送电子邮件的收件人数量以及查看预览的选项。选择发送(Select Send)预览。
几分钟内，您的收件箱将收到一封标有“测试(Test)消息”的电子邮件。合并标签将填充列表中的第一个收件人或默认值（如果适用）。
查看预览后，您可以返回“撰写”(Compose)窗口以进行任何您喜欢的调整。当您准备好发送电子邮件时，请按照相同的步骤操作，并在“准备发送”窗口中选择“全部(Send)发送”(Send)。
您可以在“已发送”(Sent)文件夹中找到您发送的邮件合并电子邮件，就像发送的任何其他电子邮件一样。
(Make Emails Easy)使用Gmail 邮件合并(Gmail Mail Merge)让电子邮件变得简单
当您需要向大众发送新闻通讯、公告或其他电子邮件时，请记住Gmail中的邮件合并功能。能够从Google 表格(Google Sheets)插入联系人、使用个性化电子邮件的合并字段以及在发送前预览邮件，所有这些都无需第三方邮件合并插件，整个过程再简单不过了。
有关其他应用程序的相关教程，请查看如何在 Microsoft Word 中(how to create a mail merge in Microsoft Word)为打印消息而不是电子邮件营销创建邮件合并。
How to Use Mail Merge in Gmail
When you want to send the same email to your customerѕ, clients, employees, club members, or a similar group, you cаn type an email once and message everyone using the Gmail mail merge tool.
Once dubbed the “multi-send” feature, mail merge in Gmail lets you insert Google Contacts or a mailing list from Google Sheets. Then, personalize your email message with merge tags, include unique unsubscribe links, and enjoy a simple bulk email process using your favorite email application.
About Mail Merge in Gmail
Let’s take a look at the Google account requirements, sending limits, and other details surrounding mail merge in Gmail.
- Mail merge is available to Google Workspace subscribers including Workspace Individual, Business Standard and Plus, Enterprise Starter, Standard, and Plus, and Education Standard and Plus.
- Supported Google Workspace accounts have a daily limit of 2,000 outgoing emails. With mail merge, you’re allowed to email up to 1,500 recipients which leaves you 500 for other emails.
- You can only add one recipient to the CC or BCC field using mail merge. Just keep in mind that this sends an email to that address for each recipient in the To field. For example, if you send a mail merge to 100 recipients, the address in the CC field receives 100 copies of that email.
- You can include attachments using mail merge; however, this counts toward your storage space. For instance, if you send a 1MB attachment to 100 recipients, you’ll use 100MB of space.
- Each message contains a unique auto-generated Unsubscribe link at the bottom in case that particular recipient no longer wants to receive your emails.
- If a recipient has previously unsubscribed from your messages and you include them in a mail merge, you’ll see a notification after you send the email with the number of recipients who won’t receive the message.
- You cannot use mail merge for replies or forwards or when you schedule emails or use confidential mode.
How to Add Recipients to Mail Merge in Gmail
While you can select the recipients for your email after you compose your message, it’s best to select them beforehand when using mail merge. This then prompts you with the available merge tags to personalize the message.
Add Recipients From Google Contacts
To get started using your Google Contacts as recipients, follow these steps.
- Choose Compose on the top left to create a new email. Use the Show main menu icon (three lines) if you don’t see Compose.
- In the Compose window, select the Use mail merge icon (contact symbol) on the far right of the To field and check the box for Mail Merge.
- You can then begin typing the names of your recipients and select them from the suggestions or select the To link and choose recipients from the Select Contacts window.
Add Recipients From Google Sheets
To insert recipients from Google Sheets, begin by making sure your sheet is set up correctly.
- All recipient information must be on the first tab of the spreadsheet.
- Each recipient and their details must be in a separate row.
- Use text-only column headers to designate the merge tags. If a header contains a special character, the merge tag is identified by the column letter instead, for example, @A for column A.
If your sheet is ready to go, choose Compose on the top left in Gmail to create the message.
- Select the Use mail merge icon on the far right of the To field and check the box for Mail Merge. Then, select Add from a spreadsheet.
- In the window that appears, use the Google Drive tabs at the top to locate and choose the Google Sheet. Then, select the Insert button on the bottom right.
- In the subsequent window, use the drop-down boxes to choose the column names containing the recipients’ details for the merge tags. Note that you may only see drop-down boxes for Email, First Name, and Last Name; however, you will see merge tags available in the email for the other details in your sheet.
- Select Finish and you’ll return to the Compose window with the name of the sheet in the To field.
Tip: If your recipient list is in Excel, look at ways to convert the Excel file to Google Sheets for the mail merge.
How to Use Merge Tags in Your Email
Once you have your recipients added to the mail merge, you’ll have the merge tags available to use.
As of this writing:
- If you add recipients from Google Contacts, you can use tags for first, last, or full name as well as email address.
- If you add recipients from Google Sheets, you can use tags for the column headers in your spreadsheet.
Add a Merge Tag
To add a tag to your email, type the @ (At) symbol with the tag name or select the tag from the drop-down list that appears.
You can add the tags to most anyplace in your message except for the email subject line and within hyperlinked text.
Preview a Merge Tag
If you’re curious how the details display after inserting a merge tag, you can easily see a preview.
- Hover over a merge tag in your message and select Preview.
- You’ll then see a window appear showing each recipient and their corresponding detail for that tag. If you have many recipients, you can use the Search at the top to find them.
- Select OK when you finish, and you’ll return to the Compose window.
Include a Default Value for a Merge Tag
You can also set default values to the merge tags. This is helpful if a recipient is missing the detail you’re trying to add. For example, if you insert the First Name merge tag and a recipient doesn’t have a first name listed, you can use a default word or phrase instead.
To add a default value, hover over the merge tag in your email and choose Set default value.
Add the word or phrase in the box that appears and select Save.
For any recipient missing the information, the merge tag in the email will be replaced with the default value.
Preview and Send Your Email
When you finish creating your mail merge in Gmail, you’ll be able to preview the email before you send it. This allows you to see the email as your recipients will so that if you need to make any changes, you can do so before hitting the Send button.
- When you’re ready, select Continue at the bottom of the Compose window.
- You’ll see a pop-up message with brief details about junk mail when sending mass emails. Select Learn more for additional information and then Got it to continue.
- Next, you’ll see another pop-up window showing you the number of recipients you’re sending the email to and an option to see a preview. Select Send preview.
You’ll receive an email labeled “Test message” to your inbox within a few minutes. The merge tags will be populated with the first recipient on your list or the default value if applicable.
Once you review the preview, you can return to the Compose window to make any adjustments you like. When you’re ready to send the email, follow these same steps and choose Send all in the Ready to Send window.
You can find the mail merge emails you send in your Sent folder like any other email sent.
Make Emails Easy With Gmail Mail Merge
When you need to send a newsletter, announcement, or other email to a mass, remember the mail merge functionality in Gmail. With the ability to insert contacts from Google Sheets, use merge fields for personalized emails, and preview the message before you send it, all without a third-party mail merge add-on, the process couldn’t be easier.
For related tutorials with other apps, look at how to create a mail merge in Microsoft Word for printed messages rather than email marketing.
