A staff member needed to send a personalize email message to multiple students in one go. The individual messages needed to have the same content but the name needed to be personalized. For instance, each student needed to be greeted by their first name while the other parts stays the same. This saves you a lot of time compared to sending individual emails to everyone. Read on to learn how to use Tmail, Google Spreadsheets and an Add-on called Yet Another Mail Merge to send a mail merge.
Tools:
- Tmail
- Google Drive
- Google Spreadsheet
- Yet Another Mail Merge (Add-on)
Tips:
- Our Google Apps license lets us send up to 1500 emails per day.
- Additional info : Yet Another Mail Merge - Webstore
Tutorial
1. Open Tmail and compose the the actual e-mail.
- To personalize the message, create "keys" like <<first name>>, that will match your Google Spreadsheet file column headers. These keys need to be the same.
- Enter a subject for the message. Don't leave this blank.
2. Open Google Drive.
3. Click the Create button and select Spreadsheet.
4. List your recipients with all the information you want to reuse in your email. The column header needs to be the same as it is in the email. Ex. firstname
5. Select the Add-on. Click Add-ons then click Get Add-ons.
6. Search for Yet Another Mail Merge and click Free button to install.
7. Click Accept. You are giving permission for the Add-on to run a merge using your e-mail address.
8. Click Add-ons then hover over Yet Another Mail Merge. Click Start Mail Merge.
9. Locate your email draft. Click the drop down arrow if you don't see your draft. Enter a Sender name. You can either send the emails now or send yourself a test email.
10. A new column will appear called Merge status. This is a confirmation that your email was sent out. Hover over the cell to see a time stamp. You can also check your Sent Mail to see the emails.
11. If you would like to reuse this Spreadsheet for a later mail merge just delete the Merge Status column.
No comments:
Post a Comment