Google’s Mail Merge tool comes to your aid when you have a lengthy list of recipients to whom you need to send the same email. You can use it to bulk-send customised emails to many people at once. Here is a step-by-step tutorial on using Mail Merge in Gmail to send customised emails.
Google offers a Mail Merge with Attachments add-on as a Google Spreadsheets extension for sending personalised emails via Mail Merge. You may send customised emails to numerous recipients, send various file attachments to each, schedule emails for transmission at a later time, track email openings and clicks, and do a lot more using this add-on in conjunction with Gmail and Google Spreadsheets.
For a new integrated look, Google will mix Gmail, Meet, Chat, and Spaces.
Open Google Spreadsheets and select Extensions > Add-ons > Get Add-ons in step 1.
Step 2: Click Install after selecting the Mail Merge with Attachments add-on.
Step 3: Authorize access to it in order for your system to instal it. The Mail Merge with Attachments add-on will show up as an option under the Extensions menu in Google Spreadsheets once it has been successfully installed.
Step 4: Select Mail Merge with Attachments under Extensions. Merge Sheet creation.
Step 5: Important variable columns like First Name, Last Name, Email Address, File Attachments, etc. are generated in a new sheet called Mail Merge. Even more variable field columns can be added if you so like.
Step 6: Select Mail Merge with Attachments under Extensions. To import any existing contact groups from Google Contacts into Mail Merge, select Import Google Contacts. The recipients’ information can also be manually entered into the Mail Merge spreadsheet.
Step 7: You can paste the links to the related files from your Google Drive into your email to add file attachments. Remember to use a comma to separate the links if there are several attachments. Alternatively, you may accomplish the same task by going to Extensions > Mail Merge with Attachments > Add File Attachments > Insert Files from Google Drive.
Step 8: After that, open your Gmail Inbox and select Compose to start writing a new message. You must utilise the field name notation while writing the email in order to include the variable fields. Actual data will be entered in lieu of these placeholders for the corresponding field in the spreadsheet. For instance, when you open an email with the phrase “Hello, First Name” in this format, the salutation is personalised for each recipient and the placeholder for First Name is changed with the names that are listed in the spreadsheet’s column for that column.
Step 9: At this point, our template is prepared. Return to the Google Spreadsheet and select Extensions > Mail Merge with Attachments > Configure Mail Merge.
To finish the Mail Merge process, enter all the sender information requested in the pop-up box and follow the on-screen instructions.
How To Google Reverse Image Search On Mobile, also read. All the Information You Need
This will enable you to send customised emails using Mail Merge in Gmail to numerous recipients at once. The Mail Merge feature proves to be a lifesaver when the recipient list is fairly lengthy. Furthermore, every email sent to the recipients is specially addressed to them, adding a touch of personalization. However, if this is your first time using Mail Merge, we suggest testing it out first before sending the actual emails.
Please let us know in the comments section below if you are aware of any further techniques for using Mail Merge in Gmail to send customised emails.