vbaoutlook

How to indicate 'please wait'


How do I indicate to the user that a macro is running within Outlook?

The macro can take 1-30 seconds to complete.

I want to avoid a modal 'msgbox' popping up before the macro is run, as this can be annoying.

Is there a way of placing a non-modal 'status' message up, whilst the macro is running?

(The macro runs against the currently selected mailItem and is launched by a button on the Quick Access Toolbar.)


Solution

  • This article (also this) on best practice says use the status bar.

    This article on Outlook says:

    Changing the Status Bar
    There is no way to change the status bar text in Microsoft Outlook. The status bar is not exposed as it is in other Microsoft Office object models.

    Outlook.com provides code for a progress box.