Creating a Distribution List from Google Sheets
Open Shared Parent Email File
- Select File > Download As > Comma-separated values (csv, current sheet)
After download >
- Open downloaded .csv file > Enter the name of your new group in column D (Group Membership) > Columns E and F do not have a corresponding name for import so you have 2 options:
Combine both columns and import with the column heading Notes or remove columns E and F
- Confirm column headings are Name, E-mail 1- Value, E-mail 2 - Value, Group Membership (you may remove second email column if you prefer only 1 parent email >
- Save file
To Import Into Contacts
- Open your email account > Switch Mail toggle to Contacts > From the "More" dropdown select Import > Import saved csv. file
- Contacts will appear individually and in the newly created group
No comments:
Post a Comment