YAMM uses the email addresses listed in a Google spreadsheet 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.
Make sure that you are logged in to your Google account.
- Open Google Sheets.
- Create a new spreadsheet 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.
Your contacts list is now ready.
You can now create an email template in Gmail for your first mail merge.