Edouard asks for some code that will automatically archive attachments on outgoing emails. Let's start with the code found at Saving Compressed Attachments and go from there.
Continue Reading: Zip outgoing attachments »
Saving attachments in 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 »
Automatically attach a file to all outgoing messages
January 27, 2010 by · 
Someone on Outlook Code asked about automatically attaching a file to new messages. You could do this two ways:
- Create a new message programmatically and attach the file.
- Use the ItemSend Event to attach the file to all outgoing messages.
Here I'll demonstrate the first way, since I've already posted code for the second way. (see Attach files to an Outlook email using VBA)
Continue Reading: Automatically attach a file to all outgoing messages »
Strip selected attachments and save to folder
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 »
CC without attachments using Outlook VBA
December 10, 2009 by · In Tip 669: CC without attachments?, Outlook MVP Diane Poremsky writes
We get often get questions from users who would like to have the option to send attachments only to the To-list, with the CC and BCC recipients just getting the message without the attachment.
Diane correctly responds that this isn't possible in Outlook. Not directly anyway, unless you want to use VBA to accomplish the same task.
Continue Reading: CC without attachments using Outlook VBA »
Follow Me