My program runs very slow

[Guest]

Hi,

I wrote a program in outlook (vba, userform). It works fine, but it takes a
long time every time I run it

Are all programs in outlook slow?
How can I make it run faster?

Thanks,
Yonina.

 

[Jay Taplin]

No, not all programs in Outlook are slow. What is it you are doing in your
code?

Jay

 

[Guest]

My program reads an email from the list, checks the address of the sender
and goes to a table in access to find the address overthere. When it finds
the address in access, it takes some data and copies it to the userform in
outlook (to labels, comboboxes etc.).
When I save the email to a table in access, it's very fast. Only the loading
takes a long time

 

[Jay Taplin]

Can you try isolating where the speed issue is? Is it at the point where
you read the e-mail from the list? Is it where you check the address of the
sender? Is it where you go to Access to retrieve the address? At that
point we can try tweaks in the appropriate place.

Jay Taplin MCP

 

[Guest]

I think the problem is when I try to find the current email in the file.
I wrote a loop that runs threw the folder and checks for each email.body in
the folder if it matches the current email message. So it depends, if I have
many items in the folder it takes more time.
Maybe I can change the loop? Do you have an idea?

 

[Michael Bauer]

Am Thu, 19 Jan 2006 00:35:02 -0800 schrieb קובץ:

Jay, you can use CDO or Redemption (www.dimastr.com) for a very fast loop
through the folder.

 

[Guest]

I can't belive you are offering me to use redemption, cdo etc.!
I tried to use it in the past with NO success! every time I tried a code
sample there was something missing and I had no idea how to fix the code to
make it work!
I finally found code that did what I wanted and works, accept it is slow
I have no idea how to use redemption and cdo. I tried going to sites that
people recommended here in the past, but they were not helpfull.