How to Create a Mailing List from a Google Docs Spreadsheet


The issue has always been that you have a spreadsheet full of contact information but you need to create a comma separated email list so you can paste them into the "To" section of your email and send it out.

For all intents and purposes I am going to assume that you aren't using a spreadsheet currently on google docs. If you are, just follow along. The rest of the steps are the same after you create a doc.

Part 1

 on How to Create a Mailing List from a Google Docs Spreadsheet

1

 on How to Create a Mailing List from a Google Docs Spreadsheet

2

 on How to Create a Mailing List from a Google Docs Spreadsheet

3

 on How to Create a Mailing List from a Google Docs Spreadsheet

4
A confirmation saying you can now run the script should have shown up. Now when looking at your spreadsheet you should see an additional menu item called "Copy & Paste Inversely" (If not: hit file and save, then reload the spreadsheet) This will be used in the next couple of steps.

 on How to Create a Mailing List from a Google Docs Spreadsheet

5

 on How to Create a Mailing List from a Google Docs Spreadsheet

6

 on How to Create a Mailing List from a Google Docs Spreadsheet

7
If so, we can move on to the final steps of the process.

 on How to Create a Mailing List from a Google Docs Spreadsheet

8

 on How to Create a Mailing List from a Google Docs Spreadsheet

9