![]() The next time you open a spreadsheet or a Google document, you will see it under Add-ons in the toolbar. Don’t forget to choose an appropriate template for your emails, too.Īnother way to do this is to install the Mail Merge add-on available on the Google Workspace Marketplace. Note that you can also install the autoCrat extension to Google Chrome to do this task. By setting up mail merge this way, you can send mass emails and control what each recipient can do with them. This particular action is a real timesaver. In that case, you’ll also see an option to send the merged files and decide if they can view or edit them.īy merely setting up a Google account, you gain access to incredibly useful tools. Suppose you have an email address column in your spreadsheet with the recipients’ data.An individual document will be created for each “first name” you have in the spreadsheet. You can also choose to save the document as a Word doc or a PDF file. After this step, you only need to name your document and choose a destination folder in Google Drive where you want to keep it.Make sure your > field corresponds with the right column header in your Google sheet, and repeat that for each merge field you have in the email. ![]() This step allows you to connect the appropriate column with the corresponding merge field.Click on Save settings and then select the sheet within your spreadsheet with the data you want to merge.In the next window, choose a template from Drive, which is the Google doc you’ve created.Click on the script and wait until the configuration is completed.You’ll now find it in the toolbar at the top. Install this script and allow it to access your document.Go to add-ons on the toolbar and search for AutoCrat.When done, click on Insert and then on Script. Now create a spreadsheet where you’ll enter the recipients’ data.You can add other mail merge fields, too, depending on how personalized you want the email to be. That’s where the recipient’s first name will be placed later. Use double brackets to mark the mail merge field identifier.Open your Google Drive and create a Google doc where you’ll enter the text of the email you want to send.This section will give you a detailed walkthrough on how you can do a mail merge using a Google doc and save time when sending personalized emails.Īnd there’s no coding required – all you need to do is install a script in Google Sheets and follow the instructions below to connect it with your Google document. If that has discouraged you, you should know that your troubles have come to an end. Struggling with your mailing list? You may have asked around about what you can do to make sending emails an automatic action, but heard you need to do some coding to make it work. Send Personalized Emails at Once How to Do a Mail Merge via Google Docs: A Step-by-Step Walkthrough
0 Comments
Leave a Reply. |