Solved

Outlook 2002 VBA Message box hidden

Posted on 2006-11-27
3
412 Views
Last Modified: 2011-09-20
Hi

I have a simple macro that checks a couple of things before sending the e-mail, a message box is displayed to the user which gives them options 'Yes', 'No', 'Cancel'.

The message box works fine on Outlook 2000 but moving it across to Outlook 2002 the message box is hidden below the outlook window and so the users do not realise it is there.

I have added vbMsgBoxSetForeground to the message box to try and force the message box to the front but this has not helped and the message box is still hidden behind the Outlook window.

Here's the message box line that I am using:

tmp = MsgBox("Test Message", vbYesNoCancel + vbMsgBoxSetForeground)

Could anyone suggest a solution to get the message box to display correctly ?

Thanks
0
Comment
Question by:duckp
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
David Lee earned 225 total points
ID: 18018312
Greetings, duckp.

Try using vbSystemModal instead of vbMsgBoxSetForeground.

Cheers!
0
 

Author Comment

by:duckp
ID: 18027791
Thanks BlueDevilFan it worked great :-)
0
 
LVL 76

Expert Comment

by:David Lee
ID: 18029923
You're welcome.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
If you don't know how to downgrade, my instructions below should be helpful.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now