Tips for customizing personalized group email: Mail Merge

Imagine the following scenario: you are planning to have a party in your house. Now you want to send an email to all your friends, or your company will launch a new product, you want to tell the media and consumers the message.

In the above two examples, the content of your email is almost the same. The difference is nothing more than a small detail such as the recipient's name. For example, when the recipient is an acquaintance, you may simply say that hi is followed by the nickname of a friend. But when you communicate with the customer, it is more appropriate to use formal greetings and titles.

However, the names of each recipient are different, which is the problem.

Want to get rid of a lot of tedious and repetitive work? Now the mail merge is amazing: it can help you send personalized emails to different users at the same time to save your time. However, this function cannot be found in Gmail and Google Apps. To use it, there are two methods:

• Method 1: You can set outlook as your Gmail mail client and then use the Mail Merge function in Microsoft Office Word. The disadvantage is that you need to send a large number of emails on your computer.
• Method 2: Use Network-based email services such as mailchimp, constant contact, and campaign monitor to send a large number of personalized emails, but they are not free of charge.

If neither of the above options can satisfy you, there is a better way: you can set mail merge to your Gmail account through Google Docs. This method is free and easy to set.

Use Gmail and Google docs to create Mail Merge



Next, we will perform the settings step by step:

1) assume that you already have a Gmail account, enter the address book, create a new group, and name it "media ". Then add all the email addresses you want to send to this group.

2) copy the workbook to your Google Docs account (click "yes, make a copy ).

3) Then you can see the mail merge option on the menu bar (on the "help" side ). Select "Import Gmail contacts (import contact)". In this case, you need to authorize Google docs to enter your address book.

4) Select mail merge-> Import Gmail contacts again, enter the group name (media here), and then the contacts in the group will be automatically added to the workbook.

5) enter the content you want to send in the green area. Subject: Mail title; salutation: mail header title; Line1-5: Mail body; Signature: Signature.

6) Select "Start mail merge" under the mail merge option in the menu ". After the email is correctly sent, the status bar of the corresponding email changes from "pending" to "OK ".

Custom Mail Merge email template

If you want to use different email templates in mail merge, you can go to tools> scripts> Script Editor and change the sendemail () function as needed.

You can find the complete macro code for the mail merge workbook here. Please read this before modification so that you can understand the Google Docs script environment. Google Docs supports attachments and HTML emails at the same time, so that you do not have to worry about creating a new template.

Through the above steps, you have successfully completed Mail Merge using Google Docs and Gmail. If you do not understand the procedure, click to continue watching the Demo Video.

Click here to view the original video.