Browse by Tags
All Tags »
Outlook VBA (RSS)
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
Read More...
An email with a coworker who was recently acquired and is getting accustomed to Outlook after years with PINE reminded me that it's been a while since I wrote any Outlook macros. Plus, I just need an excuse to write some code, I haven't written any in
Read More...
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
Read More...
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.
Read More...
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
Read More...
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
Read More...
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
Read More...
I've blogged previously about how to create a new toolbar button that runs a macro you've written. Another neat trick about this is to change the icon on this custom toolbar button to be more relevant. I have custom macros to do things such as: Create
Read More...
1. View | Toolbars | Customize 2. On the Commands tab, click Macros on the left-hand side 3. Drag the appropriate macro to the standard toolbar (say, next to the “Send/Receive“ button) 4. Right click on the button and change the Name field
Read More...
1. Start Outlook 2. Tools | Macros | Security 3. Choose “Medium”, which will prompt you on whether or not you want to run macros (VBA). You may need to restart Outlook at this point in order for that setting to take effect. 4. Tools | Macros
Read More...
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,
Read More...
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
Read More...
