I recently started my own monthly newsletter, Mystery Tin Monthly, and I wanted to make sure I got most of my contacts onto the mailing list. For the sake of transparency, I have a somewhat “large” social presence (FB: 1403, T: 550, LI: 698) and I have a ton of contacts in my Gmail.
Here are two helpful hacks to get e-mail addresses, specifically from LinkedIn and Gmail:
- Starting at your LinkedIn Profile page, on the right sidebar, under the advertisement, click on the “More” button. This is buried among the other links for “About,” “Help Center,” etc.
- Click “Manage your account and privacy.”
- Scroll down to “Getting an archive of your data.”
- Choose the “Fast File Only” option, which will deliver your profile information, connections, and messages. This will generate an e-mail containing a .zip, arriving approximately 10 minutes later.
- Inside the .zip file is a number of .csv spreadsheets, but the one we’re looking for is connections. Open it.
- The .csv file is a breakdown of your connections: First Name, Last Name, E-mail Address, Company, etc.
- Import this list into your newsletter database and you’re all set!
- Starting inside your primary e-mail account, click the white grid in the top right corner to access your “Google Apps.”
- Scroll down until you reach Contacts. (Duh?)
- You will see a screen that has your “Frequently Contacted” list and below that, your “All Contacts” list. On the left side, at the bottom of the menu, click the “More” button.
- This gives you a list of options, including “Export.” The new, preview version of Google Contacts doesn’t support exporting at the moment (Get on it, Google!), but when you click “Export” it gives you the following options:
- Click “Go To Old Contacts,” which will bring up a new window with everybody you’ve ever e-mailed.
- Select the “Other Contacts” link on the left sidebar, then use the “Select All” box at the top of the list. With all your “Other Contacts” selected, click the “More” dropdown menu and select “Export…”
- This brings up a menu of download options, specifically which lists you’d like to export. At this point, I select “All Contacts” and export as a Google .csv.
- Important Note: The list generated here is going to include every e-mail address you’ve ever contacted. This means mailing lists, info e-mail addresses, etc. It is smart to go through this list and refine it, removing the useless e-mail addresses you are sure are going to either bounce back or unsubscribe. It’s going to take a little bit, but you’ll get into a rhythm and narrow it down to the contacts you really want to e-mail.
- Import this refine list into your newsletter database and you’re all set!
Using these two simple “hacks,” my newsletter will reach nearly 1,000 people next month!
Do you have any helpful hacks for collecting e-mail addresses? Share them below in the comments!
Did you like this post? Check out some of our other popular Mystery Tin posts!
Hiring My First Freelancer is a post about my first foray into outsourcing lead generations from a virtual assistant in India, using Upwork.com.
The Wisdom of Shark Tank is a mega-post of the insight I gained by watching every episode of the investment show Shark Tank.
Starting A Monthly Newsletter is a look at the inner workings of my new Mystery Tin Monthly e-mail newsletter. (You can sign up here!)
How to Run a Successful Crowdsourcing Campaign is a fantastic overview of the nuts and bolts in running a crowdsourcing campaign.