This article explains how to send one campaign with different content for groups of recipients by reusing a unique email template.
This option is useful to:
- send emails with personalized content to different groups of people in one campaign
- reach a broader target audience in one go
- disseminate a wider source of information
- save time
1. Create your draft with the {{Message}} marker
You can add the {{Message}} marker or any other markers associated with your content column.
warning The name inside your marker {{}} must exactly match the column header of your spreadsheet, as YAMM is case sensitive.
2. Write the different versions of your content directly in your spreadsheet next to each recipient
As an example, we used the {{First Name}} and {{Message}} markers.
info You can create as many markers as you want to personalize your emails.
3. Run YAMM to send personalized content in one campaign to your recipients
After creating your Gmail draft and your spreadsheet, select Add-ons > Yet Another Mail Merge > Start Mail Merge.
Then select the draft you created in your Gmail account next to Email Template and click Send emails.
Each recipient receives an email with personalized content.
info Learn more: Personalize your email content with markers
Comments
4 comments
Hi,
Can I use multiple drafts in a single email campaign.
For eg:
Name Draft Email
Arun Letter1 a@g.com
Nora Letter2 n@g.com
so
Letter1 sends draft1
Letter2 sends draft2
Yes I would like to know this as well
I would like to know if the task described below would be possible with YAMM with no need of complex coding. Let me explain it
The problem is to organize a set of people into teams, then to assign a leader to each and every team, and finally to send a message to each and every leader with the information of his team. This is a common problem in many organizations like schools (teachers and pupils), projects (team leaders and team members), and many others.
It is convenient to organize these data in a Google Sheets book with two sheets, in order to send specific messages in the future, i.e. for teachers and for pupils in a school. Imagine we have these two sheets as follows
Team leaders list
team name
leader name
leader email
A
name X
name X@gmail.com
B
name Y
name Y@gmail.com
C
name Z
name Z@gmail.com
Team members list
member name
member email
team
member 1
member 1@hotmail.com
A
member 2
member 2@hotmail.com
A
member 3
member 3@hotmail.com
A
member 4
member 4@hotmail.com
B
member 5
member 5@hotmail.com
B
member 6
member 6@hotmail.com
B
member 7
member 7@hotmail.com
C
member 8
member 8@hotmail.com
C
member 9
member 9@hotmail.com
C
The problem I would like to solve is to send a message to each and every team leader from the “Teams leaders list” with information extracted from the “Team members list”. It is clear that this can be done through the creation of a set of separate files with team information (i.e. one for team A, one for team B, and so on), but the point is ¿is it possible to do it within YAMM with no need of extra files?
Hi Luis,
Currently it's only possible for YAMM to pull information only from 1 spreadsheet.
You could possibly add columns in the spreadsheet with the information of the members and then use markers to add that information to the email.
I hope this helps!
If you have any further question on this, please reach out to us by heading at the bottom of our website, click on contact us and submit a request there.
Regards,
Omiros - YAMM support team
Please sign in to leave a comment.