Strip attachments from Outlook calendar items

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

My boss was complaining this morning that he was getting a "Mailbox is full
message", but when he looked at it, 40M of the 100M capacity was in his
calendar.

He did some browsing, and found that he had a lot of calendar items that
have attachments (the original email, pertinent documents, whatever).

I'm an Access developer, and have done no Outlook VBA work, so I have zero
knowledge of the Outlook object model.

Does anyone have a code example that I could use that would allow me to
enter a date, and search backwards from that date through calendar items to
identify those with attachments, and then strip the attachment from the
calendar item?

I know I can do some of this by just changing the view, sorting by the
attachment, and then opening and deleting, but he is rather lazy.
 
You can see the object model in the object browser (f2). See the
Items.Restrict or Items.Filter function, which might help you to filter the
items.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 4 Dec 2008 09:14:01 -0800 schrieb Dale Fye:
 
Thanks, Michael.

The boss thought he was going to have to open each calendar item to
determine whether it had an attachment, and then delete the attachment if he
no longer needed it.

We figured out how to change the view within Outlook to view all calendar
events in a list, then sorted on those with attachments. Then he reviewed
those. It made the job more tolerable, but still not "pleasant".

I may still play around with this, was just hoping that someone else had
already done it and was willing to share their code.

--
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top