YAMM uses the email addresses listed in a Google sheet to send mail merges. All you need to do is name one of the columns Email and list any other contact information in additional columns.
About this task
To illustrate a basic contacts list, we demonstrate how to add and fill the columns Email, First name, and Last name in this order. For the purposes of each mail merge, only the Email column is required. You can use each additional column to send further personalized information to each recipient.
Prerequisites
Make sure that you are logged in to your Google account.
Procedure
- Open Google Sheets.
- Create a new Google sheet by selecting Blank under Start a new spreadsheet.
- In the first row, define the column names Email, First name, and Last name.
The only requirement is that you correctly type the name of the Email column. The order in which you define the column names does not matter.
- Fill out data for the recipients of your first mail merge.
Result
Your contacts list is now ready.
What’s next
You can now create an email template in Gmail for your first mail merge.
