Exporting email addresses from Microsoft Exchange
Dec 26, 2008
It seems like mail server software from the largest software company on earth would include an easy way to export email addresses for printing or use by other programs. Unless I’m missing something, that is not the case. It can be done, but it takes some work. Here is how I accomplish it:
- From within Outlook, click on File > Folder > New Folder
- Give it a name, such as BernardoIsCool
- Pull down the list of options beside “Folder Contains:” and select “Contact Items”
- Select Contacts as the location to place the folder, and click OK
- Click Tools > Address Book
- From within the address book, click Tools > Options
- Under “Keep personal addresses in:” choose the folder you created in Step 2
- Click OK
- Select all of the addresses in the address book. Because neither CTRL+A nor the edit menu will help you with this (What is up with that, Billy?), click on the topmost address and then use SHIFT+PAGE DOWN to select the rest.
- Right-click on one of the selected addresses and click “Add to contacts”
- Close the address book, and go to your Outlook Contacts. Select the newly created folder and you should see everybody in the global address book.
- Finally, use File > Import and Export tool to get the list of addresses into a CSV (comma-separated text file). You can then use Calc or Excel to get rid of the extra columns.
