Create email lists from Google Sheets
You can easily create a mailing list from email addresses stored in a Google spreadsheet. We present two methods.
Quick and dirty: Correctly edit Google spreadsheet
The most efficient way to send a message to all email addresses is to modify the Google spreadsheet yourself.
- If, for example, you have all the email addresses in column A in your table and column B is still free, write in cell B1, i.e. for the first email address = A1
- In the cell below, write = CONCATENATE (B1; ";"; A2) This will connect the first two e-mail addresses in this cell and separate them with a semicolon. Now click on cell B2 again, click in the lower right corner and hold the mouse button down while dragging down to the last e-mail address.
- All email addresses are now listed in the last cell. You can copy this and enter it as a recipient in a new email, for example in Outlook.
A little more complex: export contacts to Outlook
The method of saving the email addresses as new contacts in Outlook is more complex. Proceed as follows:
- Save the Google spreadsheet as a .csv file. To do this, click on "File", "Download as" and select "Comma separated values (.csv, current worksheet)".
- Now switch to Outlook and click on the "File" tab, select "Open" on the left and go to "Import".
- Select "Import from other programs or files", click "Next" and enter "Comma separated values (Windows)".
- Now open the .csv file you just downloaded.
- Select the "Contacts" folder as the target folder.
- Now click on "Assign user-defined fields" in the top right corner and check whether the e-mail address is also assigned in the correct field. If not, drag and drop the email address into the Email address field. Confirm with OK".
- Now click "Finish" to import the contacts.
- Now switch to Contacts in the bottom left corner of Outlook.
- Now select "New contact group" in the "New" area at the top left.
- Now define a name for the group and add the desired email contacts to the group via "Add members".
- Now click on "Save & Close" at the top left. You can now enter the name of the group as the recipient of every new email, which means that everyone in the group receives the message.
The instructions were carried out on a PC with Outlook 2010. For other versions, the process can vary slightly.