Sneaky Outlook VBA question

[NewOrderFac33]

Good morning - I hope that if nobody on here can help that you can point me to the MrExcel equivalent for Outlook!

I have a simple Outlook rule that runs the following VBA macro whenever a mail containing specific wording is received.

Sub AuthRelToUAT(item As Outlook.MailItem)
    MsgBox ("UAT Release in the Queue!")
End Sub

However, if Outlook isn't "on top", the MsgBox obviously isn't seen until the user switches the focus to Outlook.

Is there any way to make the macro activate Outlook, to make sure that the user sees the MsgBox?

Thanks in advance

Pete

 

[NewOrderFac33]

Here's the script that I used:

Sub AuthRelToUAT(item As Outlook.MailItem)
    Application.ActiveExplorer.Activate
    MsgBox "UAT release in the queue!", vbOKOnly + vbMsgBoxSetForeground
End Sub

Note the parameter. Note that this can't be called via Alt+F11

Pete

 

[Steve_R]

Good morning - I hope that if nobody on here can help that you can point me to the MrExcel equivalent for Outlook!

Pete

I visit Slipstick.com for Outlook information. They run a forum but I never used it.

https://forums.slipstick.com/