Open Select Case or MsgBox in Outlook from Excel VBA Code

**Gordonmyles** · 11-03-2020, 03:34 PM

Hi Guys,

As per the title I'd like to flash up a Modal Select Case msgbox over a new olMailItem I'm creating via Excel. Everything works as expected, I just can't get the box to act either systemmodal or to pop up over the new email rather than remain in the excel window!

Any ideas gratefully received.

Thanks

G

**Norie** · 11-03-2020, 03:55 PM

Can you post your current code?

**Gordonmyles** · 11-03-2020, 04:15 PM

Hi Norie,

Thanks for your reply. There is nothing exciting about the code, it just opens a new email an populates a few fields so it's more that there is a line missing, I'd expect (hope) to add a line before the Select Case to flash the message in outlook rather than excel or make it system modal

G.

Please Login or Register  to view this content.

Open Select Case or MsgBox in Outlook from Excel VBA Code

LinkBack

Thread Tools

Rate This Thread

Display

Open Select Case or MsgBox in Outlook from Excel VBA Code

Re: Open Select Case or MsgBox in Outlook from Excel VBA Code

Re: Open Select Case or MsgBox in Outlook from Excel VBA Code

Thread Information

Users Browsing this Thread

Similar Threads

How would I open a MsgBox or Inputbox in Excel, but from Outlook's session?

VB Code to select Outlook email content and paste in Excel file

[SOLVED] Multiple Select Case to open exact UserForm

[SOLVED] Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)

[SOLVED] Disregard case in VBA code. (UCase, LCase, Select Case)

[SOLVED] How to display a msgbox as soon as the outlook is open.

msgbox(select one of the open workbooks)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions