This post can also be alternately entitled, “How to Facebook and Twitter friend everyone who’s ever emailed you – ever.”

If you’re building up your “Rolodex,” this tip trick is priceless. Over the years, I’ve collected thousands, no, hundreds of thousands of emails. Funny thing is that while I may have nothing to say to 99.99% of these people who’ve emailed me in the past, I’d love to have them as twitter followers and facebook friends. The beauty of twitter and facebook is that they both allow you to import your gmail contacts. Yay!

But before we can do that, we have to extract the senders’ email addresses and store them as contacts first.

There are a couple ways to do this. First, the most rapid way is to simply export all your emails into a spreadsheet and re import only the FROM fields. This isn’t that hard to do. Just read about importing email addresses to gmail. And of course, you’ll need to know how to use Excel. It’s simple too.

- turn gmail’s pop/imap settings on

- download all your gmail to Microsoft Outlook

- export all messages as csv

- import only the email and name columns into Excell

- save as csv for import back into gmail as contacts

Or if you just want to add email addresses to your contacts selectively, one at a time, all you have to do is either

- reply

- forward

- or mark sender as “Not Spam.”

The third one is the least invasive.

Complete tutorial: http://sparkah.com/2010/06/11/how-to-export-gmail-inbox-messages-as-csv-then-extract-all-senders-email-addresses-for-importing-to-facebook-twitter-linkedin-and-sparkah-com-2/

If you have any questions about marketing your company, service, or iphone app, let’s get together and team up… find me at http://twitter.com/journik say hi! I’d love to hear about what you do!

Posted via web from I’m just amazed. Via: How to Automatically Add Inbox Email Addresses to Facebook, Twitter, Linkedin