Adding GMail’s Archive button to Microsoft Outlook 2007
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:
- Make a new folder in Outlook called Archive.
- Open the macro editor under Tools > Macros > Visual Basic Editor.
- Open ThisOutlookSession under Project1 in the Project Explorer window at the left side of the screen.
- Paste the following code:
Option ExplicitPublic Sub ArchiveSelectedItems() MoveSelectedItemsToFolder "Archive"End SubPrivate 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 Next Exit SubErrorHandler: MsgBox Error(Err)End Sub
- Save and close the editor.
Now the archive macro has been created. Let’s add a button that will trigger it:
- Click on View > Toolbars > Customize, and select the Commands tab.
- Scroll down to the Macros category.
- Drag the Project1.ThisOutlookSession.ArchiveSelected command to a toolbar.
- Right-click on your new button, and rename it to Archive Selected. Set it to display Text Only.
- Click Close.
All done!