Prevent freezing during macro execution?

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.
 
M

Mark McGinty

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.

Try calling DoEvents in your loop.


-Mark
 

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

Top