Outlook VBA

• Automate Outlook
• Change any Outlook Item Property from Excel
• Create Followup Task Reminders with VBA
• Delete Expired Items
• Etiquette Check
• Excel Automation
• Going on Vacation with Outlook
• Mailing List Management in Outlook 2003
• Outlook 2003 Object Model breakdown — The NoteItem Object
  • NoteItem Methods
  • NoteItem Properties
• Outlook 2003 Object Model breakdown — The TaskItem Object
  • TaskItem Events
  • TaskItem Methods
  • TaskItem Properties
  • TaskItem Workflow
• Outlook 2003 Object Model breakdown — The AppointmentItem Object
  • AppointmentItem Events
  • AppointmentItem Methods
  • AppointmentItem Properties
• Outlook 2003 Object Model breakdown — The MailItem Object
  • MailItem Events
  • MailItem Methods
  • MailItem Properties
• Outlook 2003 Object Model breakdown — The PostItem Object
  • PostItem Events
  • PostItem Methods
  • PostItem Properties
• Outlook File Request System
• Redirect Messages
• Remember your Outlook settings
• Reminder Event Handling
• Resend This Message
• Stock Event Code
• Utility Functions for use with Outlook 2003 VBA
• Where do I put my Outlook VBA code?

Microsoft Outlook VBA Code Samples

Here are links to my Outlook VBA code samples. There are many more on my blog. I also have some generic Outlook VBA routines below.

To assign a macro to a toolbar button in Outlook, see How to assign a macro to a toolbar button.

Don't forget to check out the Video Tutorials page!

Periodically you will see new articles added to this section. To receive notification when new articles are published, subscribe to the site feed.

Lunch Special

    A routine (that works in Excel as well) that pops up a MsgBox with a random msg. In this case, it's a fun app that helps me choose what to eat for lunch. I can see many other uses for this code. I use the same code in the Application_Startup event to pop up a random msg when Outlook starts.

    I attach this code to a toolbar button to run it on demand. If you have a different number of options, simply change the "5" in the code to whatever number you want. For example, if you had 10 options, the code would read X = Int((10 – 1) * Rnd + 1). Then you would need to add additional "Case" statements as appropriate. Hopefully your meal choices are better than mine.

Create Excel Workbook (From Outlook)

    This is a simple routine that generates a blank Excel workbook from Outlook. Optional: set a reference to the Excel application library from the Outlook VBIDE. You don't have to set the workbook Visible property to True if you want to write anything to it. At this point you can you use any Excel VBA techniques on the workbook — they work the same as if we were operating in the Excel VBIDE.

Lunch Reminder

Speaking of lunch, here's a way for all you cardpunchers out there to keep track of when you need to punch in after lunch.

This code creates a Task reminder for slightly less than an hour after you run the macro. So if you leave for lunch at 12pm, run the code and a Task will appear around 12:55, reminding you that you are just another office drone (like me) that needs to punch in to get paid.

If you want to add this to a toolbar button, run the following code:

For an explanation of how AddToolbarButton works, visit Create Outlook toolbar buttons using VBA.