On the next screen, select the email draft you created in Step 3 under email template. ![]() You can send up to 50 recepients by clicking continue on the next screen. Start Mail Merge under Add-ons > Yet Another Mail Merge > Start Mail Merge. Go back to your Google Spreadsheet from Step 2. Make sure the information you include in the brackets matches the column headers exactly as this plug-in is case sensitive. Using double curly brackets, include fields as placeholders for and/or any information you would like to personalize for each email. In your Gmail box, compose a new email message to create your email template. Alternatively, input contacts manually using separate columns for Email Address, First Name, Last Name, and any details you would like to include to personalize the message. ![]() Using Google Spreadsheets, import your contacts to a new workbook. Mail Merge Using G Suite (Gmail, Contacts, Google Sheets)įollow this link to download the Google Spreadsheet add-on, or open a Google Spreadsheet and click on Add-ons > Get add-ons and search for “Yet Another Mail Merge." We have put together this step-by-step explanation on how to mail merge and set up emails sent to relatively large mailing lists using Gmail and G Suite with the plug-in Yet Another Mail Merge. When you need to send a large number of personalized emails, but not enough to justify using a full marketing automation platform, mail merge can be a powerful tool.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |