This is the ItemAdd tag.


Outlook icon

Saving attachments in Outlook

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 »

Outlook icon

Strip selected attachments and save to folder

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 »

Outlook icon

Save Outlook 2003 E-mail Attachments Automatically

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 »

Random Data Generator