Filling arrays with Calendar items

  • Thread starter Thread starter devlei
  • Start date Start date
D

devlei

I use a "For Each objItem in objItems" loop to go through all the
items in my Calendar folder, in order to place data into different
arrays according to the items Category.

The problem is that it seems to take too long. For the approx 400
items in the folder, it takes 30 seconds. Is this normal?

Working with the same arrays thereafter and doing similar data
processing is virtually instant, so the fault doesn't seem to be with
the arrays, but with the looping through the Calendar items. Does this
sound correct? I seem to remember that when using Outlook's Import
and Exporting command to export to Excel or Access, the process also
takes a long time to complete.

With thanks
Dave
 
Hi Dave,

unfortunately for the OOM this is normal. You can use CDO instead. It´s
optional and you maybe have to install it first from your Office-/OL CD.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving Calendar items to a folder 1
Setting dimensions for Dynamic Arrays 6
Find Calendar Item from Location 3
CDO hanging on Logoff 4
creating calendar items VERY slow 1
how to Tableize emails from outlook into access 2007 0
Outlook 2007 - Getting Note Body 6
Adding appointment to non default calendar 6

Back
Top