KC Lemson

By KC Lemson [MS]

Browse by Tags

Related Posts
  • Blog Post: Now *that's* a user scenario...

    Try this. Open up word, make sure automatic spellchecking is on, and type in the names of some star wars characters:       I love it. They're in the dictionary... except, for some reason, for Leia. For the ones it does know, it even capitalizes the first letter for you if you type it lower...
  • Blog Post: Configure Sharepoint 2003 to store versions of your documents

    My relationship with Sharepoint is a love/hate story. I've been using it since its original incarnation as the "departmental server" many years ago (trivia: and it was built on the Exchange store ), but not heavily until the last year or two with SPS 2003. The first six months I [was forced to] use...
  • Blog Post: How to add a custom toolbar button and give it a tooltip

    Bob asked in the comments on this article if it's possible to add a tooltip to a button. Here's one way to do it programmatically for your own buttons. The below example adds a custom button to the standard toolbar and assigns it a tooltip. Note that the button does not actually do anything in this sample...
  • Blog Post: Count the number of items in your entire mailbox

    First, let me preface this entry by saying that I am an abysmal programmer. I use my basic programming skills to write code that helps me do things in the applications I use, and since these are usually one-time things, I don't worry too much about performance or error checking. Phew, now that that...
  • Blog Post: Add toolbar buttons for your Office macros

    I stumbled across a link to this article on slipstick earlier today while researching some VBA things, and it's so simple I wanted to share it: How to assign a macro to a toolbar button in Outlook 1. View | Toolbars | Customize 2. On the Commands tab, click Macros on the left-hand side 3. Drag the...
  • Blog Post: Set flags on multiple items at once

    In Outlook 2003, you can change properties on multiple items at once. Some examples of when this is useful is to flag or set categories on the items. 1. Select the multiple items in the view 2. Click the flag column in the default view - or - right click and set a category - or - right click and set...
  • Blog Post: Quickly view the internet headers of a message in Outlook

    Just about anyone who runs mail servers needs to look at headers from time to time. This is especially true during the development of product such as Exchange, as we track down and fix bugs. I wrote this little macro to make that a little easier. Select a message, click the button to run the macro, and...
  • Blog Post: Use the unicode smiley emoticon in email

    When you type ":-)" in Word, it automatically corrects it into a smiley ( J )[1], which is the letter J in the Wingdings font. If you look at the HTML, you'll see: <span style='font-size:10.0pt;font-family:Wingdings;color:maroon'>J</span> If you would rather that it use the unicode smiley...
  • Blog Post: More on cleaning up Word's HTML

    Brian Alvey points to a Word HTML cleaner , as well as explains why Word puts all those extra tags into HTML when you save a word doc as HTML, or copy from Word into another HTML editor. Also see my previous post about reducing the size of the HTML that Word creates when used as an email editor. [via...
  • Blog Post: Least obvious yet terribly useful Outlook/OWA calendaring feature...

    While reviewing some custom OWA themes we're developing, one of the designers pointed out this odd orange mark halfway through one of the numbers on the calendar view, wondering if it was a bug in the CSS in the custom theme: Actually, it's one of these tiny little details that I think is so slick...
  • Blog Post: Explore the different formats in which you can save data from Office applications

    A few months ago I posted about [what I think is] a neat way of using Outlook's ability to save as HTML . Today when compiling a powerpoint presentation , it occurred to me that there are a lot of formats that Office applications can save into that I find useful, and it's worth highlighting a few more...
  • Blog Post: Publish a web part on your sharepoint site that can be dynamically consumed inline by other sites

    The Exchange team uses sharepoint portal server for a lot of things, such as storing & tracking documents & lists & whatnot. As the release manager, I own the site that has the master schedule on it. There are other teams that used to have a schedule listed separately on their own sites....
  • Blog Post: Count the number of folders in your mailbox with Outlook VBA

    A coworker asked me today if I knew how to count up the total number of folders in his mailbox, in the process of troubleshooting a bug related to having a large number of folders. I had an old script that recursed through a mailbox to count the total number of items (also written for the purposes of...
  • Blog Post: Sort data in Excel in "High, Medium, Low" order

    Occasionally I have data that looks like this, sorted on the "Value" column: It's always annoyed me that Excel couldn't read my mind and figure out that I wanted to sort them in "High, Medium, Low" order. Recently I found out that it is possible to do this by creating a "Custom List" in excel...
  • Blog Post: How to add a toolbar button & hotkey to empty the junk e-mail folder in Outlook 2003

    I saw this discussion on Jonathan's blog , so here's one option: #1: Follow the instructions in this article with this code: Public Sub EmptyJunkEmailFolder() Dim outapp As Outlook.Application Set outapp = CreateObject("outlook.application") Dim olitem As Object Dim fldJunk As Outlook.MAPIFolder...
  • Blog Post: Pressing backspace in Microsoft Word doesn't delete the text

    This has happened to me a couple of times, and I don't know how, but I got into a state where when in Word, when I selected text and pressed the backspace key, it would move the cursor to the front of the word instead of deleting the text. The delete key still worked. To fix this, check this box: Tools...
  • Blog Post: "You forgot to attach the file!"

    Yikes, it's been a while since I've posted... and to think for the first 9 months of this blog, I think I posted every single day. I guess I just don't have that much content and I wore it out early... but in reality I think it's more due to my new working arrangement and being more focused when I'm...
  • Blog Post: How do you manage your mail?

    3 months before I moved out here and started working at Microsoft, a friend of mine told me: "KC, you need a pilot... because you have the organizational Zen, but not the tools required to implement it". Little did I know that I would shortly find that tool, and it would be Outlook. I apparently give...
  • Blog Post: How to filter out rows with duplicate content in Excel

    If you have data in Excel and you want to hide rows with duplicate entries, it's super easy: 1. Select the data you want to filter 2. Data | Filter | Advanced Filter 3. Click “Unique Records Only“ Excel will then hide rows that are duplicates of each other. I use this when putting together...
  • Blog Post: Keyboard shortcuts to go to the Font & Font Size drop-downs in some Office applications

    In certain Office apps that support it, such as Word & Outlook, I have “Show shortcut keys in screentips” enabled (right click on a toolbar, choose customize, and it's on the Options tab in certain of the apps). Normally, this displays the keyboard shortcut combinations (like Ctrl+Shift...
  • Blog Post: A poor man's mail merge

    Several times in the last few months I've needed to send the exact same mail content to a list of people, but each mail had to be separately addressed, for the following reasons: I am expecting each recipient to reply and continue the thread with me. This way there's no risk of "Reply All...
  • Blog Post: Get text pasted into Word/Outlook to format properly

    If you're like me and do a lot of copying content from other applications into Word and Outlook, you're probably very accustomed to using the paste smarttag to choose whether or not to use the source or destination formatting on paste. If you're tired of constantly switching it and want it to use the...
  • Blog Post: New download to remove 'hidden' data from Office files

    A coworker pointed this out to me recently. Looks pretty nifty. I've been sent documents before that were supposed to be final, but the change tracking information was still in it. Works with Word/Excel/Powerpoint 2002 & 2003. http://www.microsoft.com/downloads/details.aspx?FamilyId=144E54ED-D43E...
  • Blog Post: How to stop IE from opening up Office docs inline

    By default, when you click on a link to an Office doc (such as on a sharepoint site), IE will open the doc in-frame. For just viewing docs this is usually OK, but it can get annoying as not all features work in this manner. So if you'd rather have IE just open the doc in the appropriate application,...
  • Blog Post: Create a task from an email

    John Durant recently blogged about his macro to create a task from an e-mail. I thought that was a great idea, so I modified it a bit to suit my purposes. I frequently take an item from my inbox and Edit | Move to Folder and move it to the tasks folder, which creates a task item. I then tab around to...