Prevent freezing during macro execution?

  • Thread starter Thread starter TimB
  • Start date Start date
T

TimB

I have a macro that, on execution, goes through all items in my Inbox
and processes each one - flagging it for attention, moving it to a
folder etc. The problem is, Outlook seems to 'freeze' during
execution, then the inbox display updates all at once when the macro
has finished executing.

Is there a way to force the display to update after each item has been
processed? It's a minor issue, but enough of an annoyance that I'd
like to fix it.
 
TimB said:
I have a macro that, on execution, goes through all items in my Inbox
and processes each one - flagging it for attention, moving it to a
folder etc. The problem is, Outlook seems to 'freeze' during
execution, then the inbox display updates all at once when the macro
has finished executing.

Is there a way to force the display to update after each item has been
processed? It's a minor issue, but enough of an annoyance that I'd
like to fix it.
Click to expand...

Try calling DoEvents in your loop.


-Mark
 
Back
Top