# How to Use Mail Merge in Gmail to Send Personalized Emails?

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "WebPage",
  "headline": "How to Perform Mail Merge in Gmail? (With Attachments)",
  "description": "Mail merge in Gmail lets you send personalized emails in bulk. Learn how you can leverage this feature to send bulk emails with attachments. ",
  "image": "https://res.cloudinary.com/mailmodo/image/upload/v1653396849/strapi/Feature_image_Mail_merge_gmail_9425570596.png",
  "datePublished": "2022-03-23T16:31:24.172Z",
  "dateModified": "2025-01-08T06:28:16.615Z",
  "publisher": {
    "@type": "Organization",
    "name": "Mailmodo",
    "url": "https://www.mailmodo.com/",
    "sameAs": [
      "https://www.linkedin.com/company/mailmodo/",
      "https://www.facebook.com/mailmodo/",
      "https://www.instagram.com/mailmodohq/",
      "https://www.youtube.com/@mailmodo"
    ],
    "logo": "https://www.mailmodo.com/static/images/logo/logo-full.svg",
    "description": "Mailmodo is a complete email marketing platform that helps email marketers to create and send interactive emails to drive growth and engagement.",
    "address": {
      "@type": "PostalAddress",
      "addressLocality": "Lewes",
      "addressRegion": "DE",
      "postalCode": "19958",
      "streetAddress": "Mailmodo Technologies Inc. 16192, Coastal Highway",
      "addressCountry": {
        "@type": "Country",
        "name": "US"
      }
    },
    "contactPoint": {
      "@type": "ContactPoint",
      "email": "enquiries@mailmodo.com",
      "contactType": "customer service"
    }
  }
}
</script>

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "Article",
  "headline": "How to Perform Mail Merge in Gmail? (With Attachments)",
  "description": "Mail merge in Gmail lets you send personalized emails in bulk. Learn how you can leverage this feature to send bulk emails with attachments. ",
  "image": "https://res.cloudinary.com/mailmodo/image/upload/v1653396849/strapi/Feature_image_Mail_merge_gmail_9425570596.png",
  "datePublished": "2022-03-23T16:31:24.172Z",
  "dateModified": "2025-01-08T06:28:16.615Z",
  "author": {
    "@type": "Person",
    "name": "Suryanarayan Pal",
    "url": "https://www.mailmodo.com/guides/author/suryanarayan-pal/"
  },
  "publisher": {
    "@type": "Organization",
    "name": "Mailmodo",
    "logo": {
      "@type": "ImageObject",
      "url": "https://www.mailmodo.com/static/images/logo/logo-full.svg"
    }
  },
  "mainEntityOfPage": {
    "@type": "WebPage",
    "@id": "https://www.mailmodo.com/guides/mail-merge-gmail/"
  }
}
</script>

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "Organization",
  "@id": "#creator",
  "description": "Email marketing software to create and send interactive emails to maximize conversions and reinvent your user journey",
  "email": "support@mailmodo.com",
  "image": "https://www.mailmodo.com/static/images/og-image.png",
  "knowsAbout": "Email marketing",
  "legalName": "Mailmodo Technologies Inc.",
  "location": "United States",
  "logo": "https://www.mailmodo.com/static/images/logo/logo-full.svg",
  "name": "Mailmodo",
  "sameAs": [
    "https://twitter.com/mailmodo",
    "https://www.facebook.com/company/mailmodo/",
    "https://www.linkedin.com/company/mailmodo/"
  ],
  "url": "https://www.mailmodo.com/"
}
</script>

<script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "BreadcrumbList",
  "itemListElement": [
    {
      "@type": "ListItem",
      "position": 1,
      "name": "Home",
      "item": "https://www.mailmodo.com/"
    },
    {
      "@type": "ListItem",
      "position": 2,
      "name": "Guides",
      "item": "https://www.mailmodo.com/guides/"
    },
    {
      "@type": "ListItem",
      "position": 3,
      "name": "mail merge gmail",
      "item": "https://www.mailmodo.com/guides/mail-merge-gmail/"
    }
  ]
}
</script>

## Table of contents

- What is mail merge in Gmail?
- When should you use mail merge in Gmail?
- How to send personalized emails via mail merge in Gmail?
- Advanced features of mail merge in Gmail
- Wrap up

People enjoy receiving personalized emails. They have a better conversion rate than generic 'Dear customer' emails. But personalization doesn't just mean inserting each customer's name into an email message.

You should leverage the data you have to send emails tailored to each of your customers. You can use **Gmail Mail Merge** to create and send personalized emails to one or more email recipients.

Let us explore how you can use Mail Merge in Gmail to send mass personalized emails to delight your customers.

## What is mail merge in Gmail?

**Mail merge in Gmail** is used to send mass personalized emails with Gmail and Google Sheets. First, you’ve to add recipients’ personalized data in Google Sheets and map it with a draft email in your Gmail account to send it.

This method is useful when sending personalized greetings, [holiday emails](https://www.mailmodo.com/guides/holiday-email-marketing/), and team reports. However, this method isn’t for everyone, and let’s discuss when you should and should not use it.

<div class="highlight-gray">
<p><strong>💡 Related guide: </strong><a href="https://www.mailmodo.com/guides/email-personalization/">An Ultimate Guide to Creating Personalized Emails</a></p>
</div>


## When should you use mail merge in Gmail?

Google allows sending only 100 emails a day for regular Gmail users and 1500 emails a day for Google Workspace users.

![Gmail email sending limit](https://res.cloudinary.com/mailmodo/image/upload/v1650452126/strapi/v2_pricing_2cf49543de.png "Gmail email sending limit")

So this method of sending emails is suitable for people who have a small audience, like a business owner who sends discount emails to his small set of customers or a college professor informing his students about a new college via emails.

But this method is not suitable if you’re a big business with a gigantic audience on the scale of tens of thousands. In this case, you must invest in an ESP like [Mailmodo](https://www.mailmodo.com/) to unlock the full potential of personalized emails since Google won’t be able to help you fully.

So now you know its pros and cons, let’s discuss how to send personalized emails using mail merge in Gmail.




 
## How to send personalized emails via mail merge in Gmail?

The entire process involves mainly three steps:

1.  Configuring your Google Sheets
    
2.  Configuring your draft email in Gmail
    
3.  Connecting both platforms and sending the emails
    

Let’s discuss these steps one by one.

### 1.  Configuring your Google Sheets

Follow these steps to set up your Google Sheets.

1. Visit <a href="https://docs.google.com/spreadsheets/d/1w8bnEEei0U5fYcOJXfA7ItdyXxnUGnQGJ4vFZrZE04Q/copy" rel="noopener" target="_blank">this Google document link</a> and click on **Make a copy**. This spreadsheet is an official Google document that contains a helpful script that’ll allow you to send these personalized emails.
    
2.  The recipient column contains email addresses and adds those you want to send emails to. Each email address should be in a separate row.
    
![Add the required data to the sheet](https://res.cloudinary.com/mailmodo/image/upload/v1650452131/strapi/v2_sheets_2_b9b095ebda.png "Add the required data to the sheet")

3.  Add the details you want and remove ones that you don’t. Customize this sheet by adding all the personal information users you want to use in your email template. For example, we got rid of the last name for this template since we didn’t need it.
    
![Edit the fields in the sheet](https://res.cloudinary.com/mailmodo/image/upload/f_auto,q_100/v1650452131/strapi/v2_sheets_3_3e79b44c9a.png)

**Note:** It is not recommended to change or remove the Recipient and Email Sent fields. Or else, you'll have to edit the corresponding code in the App Script, which can mess up your project. So keep them as they are.

### 2.  Configuring your draft email in Gmail
    

Follow these steps to set up your draft email in Gmail.

1.  Click on the **+** and add **{{Recipient}}** in the **To** text field.
    
![Add {{Recipient}} in the To text field](https://res.cloudinary.com/mailmodo/image/upload/v1650452122/strapi/v2_gmail_1_972dc80f46.png "Add {{Recipient}} in the To text field")


2.  Write your subject line and add some personalized information if you want to. For that, you’ve to add the column name inside curly brackets.
    
![Add personalized subject line](https://res.cloudinary.com/mailmodo/image/upload/v1650452122/strapi/v2_gmail_2_e646ac998b.png "Add personalized subject line")


3.  Finally, configure your body text and add your desired personalization the same way you did in the subject line.
    
![Create personalized body content to mail merge](https://res.cloudinary.com/mailmodo/image/upload/v1650452122/strapi/v2_gmail_3_daaa456321.png "Create personalized body content to mail merge")

4.  Now copy the subject line of this email and close the Gmail tab.
    

Follow these steps in the previous Google Sheet to send your bulk emails.

### 3.  Connecting both platforms and sending the emails
    

Follow these steps to send your bulk emails in Google Sheets.

1.  In the top navbar in Google Sheets, click on **Mail Merge > Send Emails.**
    
![Click on Send Emails under the Mail Merge menu in Google sheet](https://res.cloudinary.com/mailmodo/image/upload/v1650452126/strapi/v2_sending_1_13bea63cec.png "Click on Send Emails under the Mail Merge menu in Google sheet")

2.  Then it will ask you to authorize the script. Click on **Continue in the popup.**
    
3.  Then choose the account in which you have configured your draft email.
    
4.  Then you’ll see the “Google hasn’t verified this app” popup. On the bottom left corner, click on **Advanced.**
    
![Verification popup](https://res.cloudinary.com/mailmodo/image/upload/v1650452127/strapi/v2_sending_4_587d1b6ae1.png "Verification popup")


5.  Scroll down and click on **Go to Gmail/Sheets mail merge (unsafe).**
    
![Click on Go to Gmail/Sheets mail merge (unsafe)](https://res.cloudinary.com/mailmodo/image/upload/v1650452128/strapi/v2_sending_5_baa76ad42e.png "Click on Go to Gmail/Sheets mail merge (unsafe)")


6.  You’ll be redirected to a screen where Google will show you what this script can do and asks you to provide your permission to run this script. Since this is an official script provided by Google, it doesn't contain any malicious code and is safe to use. So scroll down a bit and click **Allow.**
    
![Click on Allow](https://res.cloudinary.com/mailmodo/image/upload/v1650452128/strapi/v2_sending_6_6f0e4d600a.png "Click on Allow")

7.  Now go back to the previous Google Sheet document and click on **Mail Merge > Send Emails.**
    
8.  Paste the subject line you copied in the popup and click **Ok.**
    

![Paste the subject line you copied](https://res.cloudinary.com/mailmodo/image/upload/v1650452128/strapi/v2_sending_8_e343f98fac.png "Paste the subject line you copied")

9.  You’ll now see the date and time in the Email sent column, which means the emails are successfully sent.
    

So that is how you send bulk emails with Gmail and Google Sheets.

But these are the tip of the iceberg. This script and method give you many other features that can come in handy, and let’s explore them one by one.

## Advanced features of mail merge in Gmail

It is very common to send Carbon Copy (CC) or Blind Carbon Copy (BCC) to someone with our email. So if you want to perform these actions, you’ve to edit the script you installed earlier. It may sound scary, but it’s relatively easy, and let’s look at how it’s done.

1.  In the top navbar, go to **Extensions > Apps Script.**
    
![Extensions in Google sheet](https://res.cloudinary.com/mailmodo/image/upload/v1650452113/strapi/v2_advanced_1_3facb495c2.png "Extensions in Google sheet")

2.  It’ll take you to the script page. To find the required code quickly, press **Ctrl + F** and paste **“bcc”** in the search bar. It’ll directly take you to the desired code, as shown below.
    
![App script page](https://res.cloudinary.com/mailmodo/image/upload/v1650452114/strapi/v2_advanced_2_d47cb7dbc6.png "App script page")

3.  You can see two forward slashes before the bcc. These are called comments, and programmers use these to make the compiler ignore these lines. To make them work again, remove the two slashes and add the respective value of the property, such as a BCC or CC email address.
    
![App script page](https://res.cloudinary.com/mailmodo/image/upload/v1650452115/strapi/v2_advanced_3_53e11c6a10.png "App script page")


4.  There are about six properties mentioned in the script, and the first four properties are self-explanatory. The **replyTo** property lets you set an email to which replies will be sent. The **noReply** property lets you send emails from a generic [noReply email address](https://www.mailmodo.com/guides/noreply-email/). Note that the noReply feature is not available for regular @gmail.com users.
    

### Adding attachments

If you need to send the same attachments, add them while creating your draft email, and every recipient will receive this same attachment.

However, suppose you want to send multiple emails with different attachments using Gmail mail merge. In that case, you've to use a third-party extension, and [Yet Another Mail Merge (YAMM)](https://support.yet-another-mail-merge.com/hc/en-us) is one of the popular options. Here's how to send personalized attachments with YAAM.

1. Go to <a href="https://workspace.google.com/marketplace/app/yet_another_mail_merge_mail_merge_for_gm/52669349336" rel="noopener" target="_blank">this link</a> to install the YAAM extension.
    
2.  Add your attachments to Google Drive and copy their sharable link.
    
3.  Create a column in your spreadsheet and name it exactly “Attachment”. In that column, add the link of a particular attachment you want to send to that recipient.
    
![Link of the attachments in Google sheet](https://res.cloudinary.com/mailmodo/image/upload/v1650452115/strapi/v2_attachments_3_39b706285b.png "Link of the attachments in Google sheet")


4.  Then in the top navbar, go to **Extensions > Yet Another Mail Merge > Start Mail Merge.**
    
![Mail merge option in sheets](https://res.cloudinary.com/mailmodo/image/upload/v1650452115/strapi/v2_attachments_4_6aea03936b.png "Mail merge option in sheets")


5.  It’ll ask you to choose the recipient column. From the dropdown, choose the column where you’ve added the recipients’ email addresses and click **Save.**
    
![Mail merge configuration popup](https://res.cloudinary.com/mailmodo/image/upload/v1650452115/strapi/v2_attachments_5_6617f0ec53.png "Mail merge configuration popup")

6.  In the next popup, click on **Alias, filters, personalized attachments…** the link at the bottom.
    
![Mail merge configuration popup](https://res.cloudinary.com/mailmodo/image/upload/v1650452121/strapi/v2_attachments_6_ef7c405971.png "Mail merge configuration popup")


7.  YAMM will automatically detect the Attachment column. Now, tick the checkbox that says **“Attach files in column C to emails sent”** and click **Back**. It may be column C, B, or D, depending on which column you’ve set up.
    
![File attachment popup](https://res.cloudinary.com/mailmodo/image/upload/v1650452121/strapi/v2_attachments_7_82f770c943.png "File attachment popup")


8.  Add your name in the **Sender Name** field, and from the **Email Template** dropdown, select the email template you’ve used in your email draft.
    
![Mail merge confirmation popup](https://res.cloudinary.com/mailmodo/image/upload/v1650452122/strapi/v2_attachments_8_69e9492ffe.png "Mail merge confirmation popup")

9.  Then, click **Send 2 Emails** to send emails. Since we have two columns, it’s saying two emails. If you’ve more columns, it’ll say that number accordingly.
    
That’s it. That’s how you send personalized emails with YAAM using the Gmail mail merge technique.

<div class="inline_cta"><div class="ctaBox"><div class="leftdiv"><p>Create and send AMP emails without coding in minutes</p><div class="button_container"><a href="https://manage.mailmodo.com/auth/signup?utm_content=inline-cta-s&utm_term=/guides/mail-merge-gmail/"><button class="primary_button">Try Mailmodo for free</button></a></div></div><div class="rightdiv"><img src="https://res.cloudinary.com/mailmodo/image/upload/v1712747193/strapi/Group_1110165064_1_57b7027899.png" width="290" height="230" alt="cta-img"/></div></div><div class="gradient"></div></div>


## Wrap up

You can send personalized emails to only a small audience with mail merge in Gmail. That’s why it’s best to opt-in for a complete email marketing solution like [Mailmodo](https://www.mailmodo.com/) if you serve a larger audience and need advanced personalization features like triggered emails, list segmentation, and personalized AMP email creation.

If you use Outlook then you can check out our guide on [how to perform mail merge in Outlook](https://www.mailmodo.com/guides/mail-merge-gmail/) to send more personalized emails.

---

**Author: Suryanarayan Pal**

Suryanarayan has 7 years of experience in email marketing for B2B, SaaS, and e-commerce, specializing in email deliverability and project management.

