Send Personalized Bulk Emails For Free

5/5 - (1 vote)

Have ever experienced a situation to send many emails? Most of the people who are reading this have experienced. But if you want to send bulk emails, you can’t customise them.

Why Send Personalized Emails

The basic form of personalizing emails is writing the recipients’ names. If you don’t write the recipients’ names, the email looks unprofessional. For example, writing “Hello Jack” is more professional than “Hello“. Nobody is going to read an email if you write it without mentioning their name. The mail looks like it is automated.

If you are sending emails with the person’s name, the chances of opening your mail increase. Let’s assume a real-life example. If you are working, customising emails is a game-changer. Suppose you want to send an email to a team and you send the email to all the members of that team.

If you customise the email, the chances of opening and reading your mail increase. So, the chances of getting replies also increase.

Problems with sending Personalized Emails

You can’t write a recipient’s name in the email directly because others reading it can’t understand the mail. If you write “Hello Jack“, other recipients think that the mail is not for them. It looks unprofessional. So, the customisation for each person is important.

But it takes a long time to send a personalised email to each person. And it is impractical and not useful in our day-to-day life. We need to send personalised emails and also not waste our time sending them.

So, this is a free process of sending personalised bulk emails easily. Here is a guide to help you do it.


Send Personalized Bulk Emails

We are going to use Google’s Mail Merge feature to do this. Here are the steps to follow.

Get Mail Merge for Free

  1. Go to Mail Merge and click on “Make a copy”
  2. You will be redirected to Google Sheets
  3. Click on “Make a copy”
  4. This is the interface you will get. Here, you can customise the Email you want to send.
  5. Google Mail Merge - Interface


You have to customise the columns of Mail Merge Google Sheet to send customised emails. You also rename this Google Sheet. The columns of this sheet are the various customisation options for the mail you want to write. Let’s learn more about these properties.


The columns are called properties (here). Let’s say we want to write an email to Jack and John. To do this, you can create a column named “Name”. You have to write their names in this column corresponding to their email address in the “Recipient” column.

You can do this not only for names but also with customer ID, client ID, employee ID, etc…

Note: All the headings in the 1st Row can be customised except Recipient and Email Sent. The “Recipient” column is for the mails of recipients. The “Email Sent” column will be updated with the time when you send an email. To remember, you can change their background colour to red.

Send Mail using Mail Merge

After setting up Mail Merge, we are ready to send our email. Let’s see how to do it.

  1. Open Gmail.
  2. Click on Compose on the left menu
  3. Write a mail like you normally would
  4. In the recipient box, type {{Recipient}} (with curly braces)
  5. In the subject & body of the mail, you can use all the properties you’ve made as columns in Mail Merge.
  6. Here is how an email looks like
  7. Mail Merge Email
  8. After writing an email, go back to Mail Merge
  9. Click on “Mail Merge” and “Send Emails” from the top menu
  10. Mail Merge - Send Email
  11. Click on “Continue” on the Autorisation pop-up, and choose your Gmail Account
  12. Mail Merge - Choose your Gmail
  13. If Google asks for Security Check
  14. Click on “Advanced”
  15. Scroll down and click on “Go to Gmail” >> “Allow”
  16. Mail Merge
  17. Don’t worry, Mail Merge is an official app from Google Developers. You can find Mail Merge even on Google’s official websites.
  18. Go to Gmail and copy the subject line of your email that you wrote earlier
  19. Come back to Mail Merge Dashboard and click on “Send Emails” again
  20. In the pop-up box, paste the subject line
  21. Mail Merge - Paste Subject
  22. Click “Ok”
  23. In a few seconds, the emails will be sent and you will see the “Email Sent” column with the time of the email sent.
  24. Mail Merge - Email Sent

Share with your friends 🙂

Sharing Is Caring:

Disclosure: This post may contain affiliate links, meaning that if you click on one of the links and purchase an item, we may receive a commission (at no additional cost to you). All opinions are our own and we do not accept payments for positive reviews. Learn More

Leave a Comment