Custom Office Programming and Automation
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.
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.
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.
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!
Copyright © 2013 Jimmy Peña · Hosted by FutureQuest · Powered by Genesis · Site Map · Legal
Follow Me