The site formerly known as Code For Excel and Outlook
February 26, 2010 by · 
People write to me sometimes and ask how they can do things with email attachments in Outlook. They want to print them, open them, copy or move them. Dammit, they want to use them! Unfortunately, there's no way to do so without saving the file first.
In other words, you can't print or open a workbook attached to an email without first saving it. Here are some methods to do so.
Continue Reading: Saving attachments in Outlook »
January 6, 2010 by · Another post in the Save Money, use VBA series.
Continue Reading: Automatically print incoming emails »
December 17, 2009 by · Removing attachments from your emails will reduce your PST file size and network footprint, but now you're left with attachments and no way to reference where they came from.
We need a way to strip attachments from a set of emails, but hyperlink to them so that we can retrieve or reference the files later, so (surprise!) we'll use VBA, both as an event handler and a one-off procedure to do this.
Continue Reading: Strip selected attachments and save to folder »
December 3, 2009 by · In Outlook 2007 Add-in: Saving Outlook e-mail attachments automatically, author Robert Martim demonstrates how to write an add-in for Outlook 2007 using VSTO that saves file attachments on incoming e-mails automatically.
I've demonstrated the same using VBA in Outlook 2003 below. It uses the stock event code I use when creating event handlers in Outlook.
Continue Reading: Save Outlook 2003 E-mail Attachments Automatically »
January 7, 2009 by · If you have multiple mail profiles set up in Outlook, you might need VBA code that acts on items in several different inboxes (instead of just your own). Typically you'll see this in an environment where Exchange Server is running. Hold on, there's a lot of VBA code in this post!
Continue Reading: Handling Multiple Inboxes »
Site last updated: February 9, 2012
Follow Me