Outlook icon

Limit attachment size in Outlook

On MSDN there's an article for Outlook 2010 that shows you how to Limit the Size of an Attachment to an Outlook Email Message. I think it needs some improvement (as well as translation to Outlook 2003 VBA). It's written by Ken Getz, a Microsoft MVP for VB.

Continue Reading: Limit attachment size in Outlook »

Automation iconOutlook icon

Merge Outlook spreadsheet attachments

merge

At OutlookCode someone asks if it's possible to append a bunch of Excel spreadsheets attached to emails in a folder. In the end, we want all the data attached to each email to reside in one spreadsheet.

Continue Reading: Merge Outlook spreadsheet attachments »

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: Save Outlook 2003 E-mail Attachments Automatically »

Outlook icon

I made it into the EMO Newsletter

Well, my comments did. In the Exchange Messaging Outlook Newsletter Volume 13, Number 36, Diane Poremsky posted the following from one of her readers:

Attachments and CC/BCC

Dave wants “a check box or other option on CC and BCC to eliminate attachments – this allows all those crazed corporate wind bags that "cc" their entire department when delivering work or some project, then everyone saves a copy and so on. Referencing the file name only would (or could given that fact that the sender would control the feature) need be referenced in the body of the email.”

I won't mention Dave's last name or his employer, just in case his crazed wind bags read this, but Dave is right – Outlook needs an option to send attachments only to those in the To field. This is a popular request, one I've heard many times over the last 10 years.

Continue Reading: I made it into the EMO Newsletter »

Automation iconExcel iconOutlook iconVBA icon

Hands Off That Email Attachment!

About halfway down the Outlook page, there is some VBA code for opening an Excel workbook attached to an email, running a macro on it, then cleaning up and moving the email to another folder.

Continue Reading: Hands Off That Email Attachment! »

Site last updated: February 9, 2012