![google mail merge google mail merge](https://blogcdn.gmass.co/blog/wp-content/uploads/2021/02/image18-1.png)
To do that, go to Add-ons > Mail Merge with Attachments > Import Google Contacts. Now, you need to add the contacts you want to use to this spreadsheet. Go to Add-ons > Mail Merge with Attachments > Create Merge Template.Ī blank mail merge template is created in the Untitled spreadsheet, containing the mandatory columns, like First Name, Last Name, and Email Address. The Mail Merge add-on opens a new Untitled spreadsheet in Google Sheets on a new tab. The Mail Merge – Getting Started Guide displays. Click Allow to give the Mail Merge add-on permission to access your Gmail account. The various permissions required by the add-on are listed. Then, install the Mail Merge add-on for Google Sheets.Ĭlick Continue on the Let’s get started dialog box to give the Mail Merge add-on permission to run. Install the Mail Merge for Gmail with Attachments Add-onīefore installing and using the Mail Merge add-on, log into the Gmail account you want to use.
![google mail merge google mail merge](https://cdn.ilovefreesoftware.com/wp-content/uploads/2020/03/Mail_merge_google_docs_using_sheets-offer_letter.png)
#Google mail merge how to#
We’ll show you how to use the Mail Merge for Gmail with Attachments add-on to personalize a batch of the same emails and send them.
![google mail merge google mail merge](https://miro.medium.com/max/1200/1*9V3zyZSFiU7NbIjLWkQnQA.png)
However, there is a mail merge add-on available for Google Sheets that links with your Gmail account. If you use Gmail as your main email client, there is no built-in mail merge feature. The information you use to customize each letter or email is taken from your data source like a contacts list. Each letter or email can include both standard and custom personalized content. Mail merge is a feature that allows you to create multiple copies of letters and emails to send to your contacts.