LinkedIn has a handy feature where you can upload your contacts file from Outlook, and it will find everyone who is also using LinkedIn so you can quickly establish connections with people you already know.

Now I don’t really use proper Outlook contacts, but I do have a pretty hefty list of e-mail addresses in my auto-complete list. You know — when you type ‘Rich’ in the ‘To’ field, and it pops up a list of full e-mail address suggestions.


Wouldn’t it be great if I could just upload this list instead? Here’s how:

  1. Download This is a free utility for viewing and exporting NK2 (Outlook Nickname Cache) files.
  2. Open, click Browse, and open Outlook.NK2 file from your %USERPROFILE%\AppData\Roaming\Microsoft\Outlook\ directory.
  3. Click Export Now (CSV) to your desktop or someplace you can easily find it.
  4. In LinkedIn, go to Contacts > Add Connections > Import Contacts > Other Address Book, and upload the output file.

Note that some of your contacts names will be in upper case. Also local domain e-mail addresses (e.g. just rdingwall with no @) will be ignored.

March 19th, 2009 | No Comments Yet

Recently, I have been using GMail as my primary e-mail client. It’s simple to use, lightweight, fast and powerful. One feature I particularly like is the Archive button, which lets me clear messages out of my inbox with a single click. Instead of letting e-mails clutter up my inbox just in case I need them again, I can archive them as soon as I’ve read them. Fewer items in my inbox makes it easier to focus and prioritize tasks, which in turn makes me more productive.

In the high-pressure environment at work, where I frequently receive up to a hundred or so e-mails a day, everything I can do to make my life easier helps. Here is how I added an Archive button to Microsoft Outlook:

  1. Make a new folder in Outlook called Archive.
  2. Open the macro editor under Tools > Macros > Visual Basic Editor.
  3. Open ThisOutlookSession under Project1 in the Project Explorer window at the left side of the screen.
  4. Paste the following code:
    Option Explicit
    Public Sub ArchiveSelectedItems()
        MoveSelectedItemsToFolder "Archive"
    End Sub
    Private Sub MoveSelectedItemsToFolder(FolderName As String)
        On Error GoTo ErrorHandler
        Dim Namespace As Outlook.Namespace
        Set Namespace = Application.GetNamespace("MAPI")
        Dim Inbox As Outlook.MAPIFolder
        Set Inbox = Namespace.GetDefaultFolder(olFolderInbox)
        Dim Folder As Outlook.MAPIFolder
        Set Folder = Inbox.Folders(FolderName)
        If Folder Is Nothing Then
            MsgBox "The '" & FolderName & "' folder doesn't exist!", _
                vbOKOnly + vbExclamation, "Invalid Folder"
        End If
        Dim Item As Object
        For Each Item In Application.ActiveExplorer.Selection
            If Item.UnRead Then Item.UnRead = False
            Item.Move Folder
        Exit Sub
        MsgBox Error(Err)
    End Sub
  5. Save and close the editor.

Now the archive macro has been created. Let’s add a button that will trigger it:

  1. Click on View > Toolbars > Customize, and select the Commands tab.
  2. Scroll down to the Macros category.
  3. Drag the Project1.ThisOutlookSession.ArchiveSelected command to a toolbar.
  4. Right-click on your new button, and rename it to Archive Selected. Set it to display Text Only.
  5. Click Close.

All done!

November 15th, 2007 | 17 Comments