Tips for Twits

We had to setup a EDM/newsletter system for a client. He wanted to consolidated his and his staff email addresses. He sent me a few outlook PST files. We imported it into outlook and found that besides the few thousand emails in the contact list, there’s another few thousand more emails in different folders which held email addresses. I figured it would be easy to extract those emails.

Unfortunately, there’s no built in way of doing it in Outlook or Thunderbird. There’s a couple of paid solutions to extract emails from the inbox folders but I had to try it a few more times. After tinkering around with Outlook and Thunderbird, I found a way to extract emails through exporting to CSV.

Simple steps to get email addresses from inbox. These steps are for Office 2007

1. Import emails into Outlook
2. Export to CSV(DOS) (See Figure 1)
3. Open with Excel
4. Select the email column and copy into a new file.
5. Save as CSV.
6. You have it. Use it anywhere you like. CSV is supported for most applications.

Figure 1

Here’s the instructions to export to CSV file.

Step 1: File > Import and Export

Step 2: Export to file

Step 3: Comma Separated Values (DOS)

Step 4: Select folder

Step 5: Export to CSV