This is the Attachments 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

Automatically attach a file to all outgoing messages

Someone on Outlook Code asked about automatically attaching a file to new messages. You could do this two ways:

  1. Create a new message programmatically and attach the file.
  2. 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 »

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

CC without attachments using Outlook VBA

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 »

excel school learn dashboards