Search through calendar for items with attachments

[Ben]

Hi

We have a significant number of items created in our calendar by a third
party application, each item has an attachment with the extension .att.

We have stopped using the third party app are starting to use a new system.

The problem is that we have many items in each users Calendar which will be
duplicated by the new system.

My thought is to write a VBA program that I will run in Outlook for each
user that searches for calendar items with the attachment .Att, list them in
a list box for me to quickly check and then click a button to delete them.

The problem is that I do not know how to search for items in the calendar.

If someone could post some example code it would be much appreciated.

Thanks
B

 

[Michael Bauer]

Am Wed, 30 Nov 2005 14:33:09 -0000 schrieb Ben:

Ben, did you consider using customized views instead of VBA? Creating the
view would take one minute per PC or less. The VBA solution would take a
beginner probably one day - plus the waiting time for advices.

For the view: Select the calendar and click "Create views..." (or something
similiar). Select a table view from the list, copy it, remove all filters
and select the filter for "Only Items with at least one Attachment" (or
something similiar).

After it´s done you can delete the view (as I think you will need it only
once per PC).

 

[Ben]

Hi Michael

Thank you for your post, although I have just finished the program.

Thanks

B