vba to close Outlook's "Enter Network Password" dialog box.
Posted on 2013-01-11
About once a week Outlook incorrectly displays the "Enter Network Password" dialog which asks us to "Please type your user name and password".
We simply click "OK" and processing resumes normally.
Unfortunately, one computer uses Outlook 2003's NewMailEx subroutine much like a server. Outlooks stays up all night receiving emails which are transfered to an Access database.
When the server gets the "Enter Network Password" dialog, the send receive stalls while waiting for user to click "OK". The dialog is non-modal, so some of my vba code continues to run, but the NewMailEx routine does not receive anymore emails.
I already have setTimer code that runs every 5 minutes. It continues to run and now detects the hang, but I don't know how to make vba respond OK or Cancel .
I tried this but it did not help.
Set SyncObject = myOlApp.session.SyncObjects.item(1)
Does any guru have any suggestions?