Mail merge

How to send personalized emails with direct mail in Gmail (2022)?

When you have a long list of recipients that you need to send the same email to, Google’s mail merge feature comes to your rescue. It allows you to send mass personalized emails to multiple recipients simultaneously. Here is a step by step guide on how to send personalized emails with Mail Merge in Gmail.

To send personalized emails via direct mail, Google provides a Mail merge with attachments add-on as an extension accessible via Google Spreadsheets. Using this add-on, along with Gmail and Google Spreadsheets, you can not only send personalized emails to multiple recipients, but also send different attachments to each, schedule emails to send later, track email opens emails, clicks, etc. After.

– Advertisement –

Read also: Google will combine Gmail, Meet, Chat and Spaces to offer a new integrated view

Step 1: Open Google Spreadsheets, navigate to Extensions > Add-ons > Get Add-ons.

– Advertisement –

2nd step: Select the Mail merge with attachments add-on and click Install.

– Advertisement –

Step 2 Mail Merge

Step 3: Grant permissions for it to be installed on your system. After successful installation, you will notice that Mail merge with attachments the add-on appears as an option under the Extensions menu in Google spreadsheets.

Step 3 and 4 Mail Merge

Step 4: Go to Extensions > Mail Merge with Attachments > Create Merge Sheet.

Step 5: A new sheet with the name Direct mail is created with important variable columns like First name, Surname, E-mail address, Attachmentsetc You can even add more variable field columns if you want.

Step 5

Step 6: Go to Extensions > Mail Merge with Attachments > Import Google Contacts to import all existing contact groups from Google Contacts into the mail merge. You can also choose to manually fill in recipient details in the mail merge spreadsheet.

Step 6

Step 7: To add attachments to your mail, you can paste the links of the corresponding files from your Google Drive. If there are multiple attachments, remember to separate the links with a comma. You can also go to Extensions > Mail merge with attachments > Add attachments > Insert files from Google Drive Do the same thing.

Step 7

Step 8: Then go to your Gmail inbox and click on Compose write a new message. When composing the email, you should use the {{ domain name }} notation to include variable fields. These placeholders will be replaced with the actual data of the corresponding field in the spreadsheet. For example, when you type- “Hi {{ First name }}…”in this format at the start of your email, the greeting is personalized for each individual, with the First Name placeholder replaced with the actual names mentioned in the spreadsheet under that column.

Step 8 Mail Merge

Step 9: Now that our model is ready, navigate to the Google spreadsheet again and navigate to Extensions > Mail Merge with Attachments > Configure Mail Merge. Add all sender details requested in the pop-up window and follow the on-screen instructions to complete the mail merge process.

Step 9 Mail Merge

Read also: How do I do a reverse image search on Google on mobile? All you need to know

This way you can send personalized emails with Mail Merge in Gmail to a large group of people simultaneously. If the list of recipients is long enough, the mail merge feature turns out to be a huge lifesaver. And each email sent to recipients is uniquely addressed to them, giving it a personal touch. However, if you are using direct mail for the very first time, we recommend that you give it a try before sending the actual emails.

If you know of any other method to send personalized emails with Mail Merge in Gmail, let us know in the comments section below.

For the last gadgets and tech newsand gadget reviewsfollow us on Twitter, Facebook and instagram. For the most recent technology and gadget videos subscribe to our Youtube channel. You can also stay up to date using the Gadget Bridge Android app. You can find the latest auto and bike news here.

– Advertisement –