Outlook 365 - Screen Not Updating During Code Execution 1

[MattGreer]

I wrote some VBA code to run through all the emails in a given folder and process them in some way. The issue I'm having is that I want to get periodic updates to the screen so I know the computer hasn't locked up. I tried to use Application.Wait but that throws up an error. I am currently using some sample code to implement "Sleep" but, my understanding is that nothing will update during Sleep.

What can I do to let Outlook "catch up" so that the screen can update and show me whatever I've put in the Immediate window (using Debug.Print)?

Thanks!!


Matt

 

[strongm]

Have a look at [tt]DoEvents[/tt] function

 

[MattGreer]

That was 100% it. Thank you! Works like a champ now, and the fact that Outlook now updates so I don't need the progress bar; I can see the email totals changing in various folders.

Thanks!!


Matt