tag:blogger.com,1999:blog-8170892423378293211.post303754483851543558..comments2020-09-04T17:42:12.057+01:00Comments on darthandy: How to get Outlook appointment reminders to pop up in front of other windows again using some simple VBA.Unknownnoreply@blogger.comBlogger31125tag:blogger.com,1999:blog-8170892423378293211.post-50838721138222572212020-09-04T17:42:12.057+01:002020-09-04T17:42:12.057+01:00I have tried this VBA code without desired success...I have tried this VBA code without desired success. Looking at the options and refusing to pay I came to a solution that worked fine for me. I'm using the Windows 10 Calendar app. I just added my account and sync calendar only and the alerts works perfect at the system tray just as I needed. Give it a chance, it may solve your need.R2https://www.blogger.com/profile/05054593208220251322noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-84555239161486467372017-09-18T20:01:01.844+01:002017-09-18T20:01:01.844+01:00I'm running the original script and was succes...I'm running the original script and was successful in having it load every time I launch Outlook (but with a permission dialog to let the macro run). It does steal focus, so when the message box is unacknowledged, Outlook will not work in the background such as downloading new mail. So when I come back to my desk and the reminder dialog is up, I need to close the dialog then update my inbox to see any new mail that came in since the pop-up. Not perfect but is helping me not miss meetings. THANKSYestorhttps://www.blogger.com/profile/02005009238501560239noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-89488239030939590422017-04-24T15:53:58.207+01:002017-04-24T15:53:58.207+01:00I can't install programs at work, and neither ...I can't install programs at work, and neither the VBA certificate nor selfcert.exe exist on my machine... I'm on Office15 and Windows 7...auntygeekhttps://www.blogger.com/profile/03817490376667442958noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-53309564332250608382017-03-03T21:31:06.727+00:002017-03-03T21:31:06.727+00:00^End Sub^End SubAnonymoushttps://www.blogger.com/profile/04015183628100524834noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-18739767744806271162017-03-03T21:29:46.548+00:002017-03-03T21:29:46.548+00:00I modified the Script as follows to: a) check for ...I modified the Script as follows to: a) check for Task and Mail Reminders also, b) add a defaulted Cancel Button and not allow closing unless OK is selected, so you don’t accidentally close it if you were about to press the Enter key right before the Window pops up.<br /><br />"<br />Private Sub Application_Reminder(ByVal Item As Object)<br /><br /> If ( _<br /> (TypeOf Item Is AppointmentItem) _<br /> Or (TypeOf Item Is MailItem) _<br /> Or (TypeOf Item Is TaskItem) _<br /> ) Then<br /> <br /> Dim MsgBoxResult As Integer<br /> <br /> Do<br /> <br /> MsgBoxResult = _<br /> ( _<br /> MsgBox _<br /> ( _<br /> "An Outlook Reminder is awaiting snooze/dismissal! Select OK to continue.", _<br /> vbSystemModal + vbOKCancel + vbDefaultButton2, _<br /> "Attention!" _<br /> ) _<br /> ) ' -- MsgBoxResult =<br /><br /> Loop Until (MsgBoxResult = vbOK)<br /> <br /> End If<br />"Anonymoushttps://www.blogger.com/profile/04015183628100524834noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-43901820886045517302017-03-03T21:27:53.571+00:002017-03-03T21:27:53.571+00:00Thanks! That worked!Thanks! That worked!Anonymoushttps://www.blogger.com/profile/04015183628100524834noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-39971051200890636192017-02-28T19:37:38.179+00:002017-02-28T19:37:38.179+00:00For Windows10Pro and Office 2016, you can create a...For Windows10Pro and Office 2016, you can create a certificate by going here: <br />C:\Program Files\Microsoft Office\root\Office16\Selfcert.exeMurrayhttps://www.blogger.com/profile/15689268713362737357noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-2205343163110598532017-02-28T05:02:01.714+00:002017-02-28T05:02:01.714+00:00"'Digital Certificate for VBA Projects..."'Digital Certificate for VBA Projects'" does not appear when I "Hit Start and type ‘certificate'". I'm on Window 10 Pro.Anonymoushttps://www.blogger.com/profile/04015183628100524834noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-19192773336895888232016-08-01T16:16:36.418+01:002016-08-01T16:16:36.418+01:00Thank you. This is efficient and still works with ...Thank you. This is efficient and still works with windows 10 using outlook 2016 as well. THE PRAGMATIC PROGRAMMERhttps://www.blogger.com/profile/04022600164936379293noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-4070823970168988712015-11-30T21:10:10.240+00:002015-11-30T21:10:10.240+00:00This is not free. The trial is free, but the actua...This is not free. The trial is free, but the actual program is $5. Would be awesome if it was free.Anonymoushttps://www.blogger.com/profile/15476674578949551319noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-7657970618813111492015-11-30T21:09:51.217+00:002015-11-30T21:09:51.217+00:00This is not free. The trial is free, but the actua...This is not free. The trial is free, but the actual program is $5. Would be awesome if it was free.Anonymoushttps://www.blogger.com/profile/15476674578949551319noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-12125421454800261852015-09-25T01:50:33.705+01:002015-09-25T01:50:33.705+01:00Thank you! I am not a programmer, and was a bit l...Thank you! I am not a programmer, and was a bit leery about attempting this, but I'm so frustrated about the appointment reminders that I frequently miss, I decided to give it a try. Your instructions were very easy to follow, and my test case worked like a charm! I have high hopes for this to settle this issue for me. I would download the program from Radaker, but we're not allowed to install programs on our work computers. Nothing that says I can't put in my own (or your own) VBA code, though. :-Danother anonymous cowardhttps://www.blogger.com/profile/14706068602728450375noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-22916672125734386732015-03-13T18:50:04.319+00:002015-03-13T18:50:04.319+00:00Alternatively you could download Outlook Reminders...Alternatively you could download Outlook Reminders On Top (free program) from www.radaker.com. It just creates an icon in your system tray, and whenever it sees an Outlook reminder either minimized or behind other windows it brings it to the front for you (like the old days). But it does NOT steal the focus from whatever you're currently working on (unlike the old days). Win-win!!Bradhttps://www.blogger.com/profile/06968795863557146844noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-14332704432405551802015-03-13T18:49:31.041+00:002015-03-13T18:49:31.041+00:00Alternatively you could download Outlook Reminders...Alternatively you could download Outlook Reminders On Top (free program) from www.radaker.com. It just creates an icon in your system tray, and whenever it sees an Outlook reminder either minimized or behind other windows it brings it to the front for you (like the old days). But it does NOT steal the focus from whatever you're currently working on (unlike the old days). Win-win!!Bradhttps://www.blogger.com/profile/06968795863557146844noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-15632988667475655542014-09-18T08:22:56.787+01:002014-09-18T08:22:56.787+01:00I've tried this and for me it puts the focus o...I've tried this and for me it puts the focus on Outlook itself. The reminder is still in the background even if the focus is already on Outlook.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-56041293351507254942014-08-01T17:11:25.635+01:002014-08-01T17:11:25.635+01:00I tested this. You actually use "Application...I tested this. You actually use "Application.ActiveExplorer.Activate" to replace the entire line that starts with MsgBox. Do not use the quote marks. It works even if you are not in Outlook.<br /><br />I hope this helps someone else.Tennessee Walkerhttps://www.blogger.com/profile/09917301298032730424noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-15684205472781705262014-05-07T21:14:19.975+01:002014-05-07T21:14:19.975+01:00Should be fine if you put it where I said - still ...Should be fine if you put it where I said - still working for me after 3+ years. Shouldn't need to faff with root certs.Darthhttps://www.blogger.com/profile/09496431432039325803noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-21895371762212284852014-05-07T16:10:28.577+01:002014-05-07T16:10:28.577+01:00I have the same problem. Please someone help.I have the same problem. Please someone help.Anonymoushttps://www.blogger.com/profile/03873050613056311711noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-30171331693404997622013-05-03T06:52:52.858+01:002013-05-03T06:52:52.858+01:00i have put this code in and it doesnt seem to work...i have put this code in and it doesnt seem to work please tell me if im doing something wrong<br /><br />Private Sub Application_Reminder(ByVal Item As Object)<br /> <br /><br /> Rem If TypeOf Item Is AppointmentItem Then<br /> Application.ActiveExplorer.Activate"Message text", vbSystemModal, "Message title"<br /> <br /> End If<br /> <br /><br />End SubZiVahttps://www.blogger.com/profile/17358101556770833631noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-9084345159025895662013-04-11T07:24:29.587+01:002013-04-11T07:24:29.587+01:00Should be sticky if you put it where I said and si...Should be sticky if you put it where I said and sign it but your sysadmin may have done policy stuff (actual technical term, honest) that blocks this kind of thingDarthhttps://www.blogger.com/profile/09496431432039325803noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-8534266013755326422013-04-11T07:22:13.294+01:002013-04-11T07:22:13.294+01:00Not sure how to decorate the message box, but '...Not sure how to decorate the message box, but 'vb decorate message box' is probably what you want to search forDarthhttps://www.blogger.com/profile/09496431432039325803noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-79329964343461780862013-04-11T07:20:47.022+01:002013-04-11T07:20:47.022+01:00If that takes focus then it's an improvement, ...If that takes focus then it's an improvement, I'll give it a go.Darthhttps://www.blogger.com/profile/09496431432039325803noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-86859737494508541032013-04-11T07:11:52.444+01:002013-04-11T07:11:52.444+01:00Yes, the problem with this is when you reload outl...Yes, the problem with this is when you reload outlook the script no longer works. It seems that outlook only allows you to create the Vba for the session that you wrote the script for. Help, can some bright spark please help. ThanksArohainahttps://www.blogger.com/profile/07903368216007626559noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-83384998206802955562013-04-11T05:29:43.788+01:002013-04-11T05:29:43.788+01:00How can I make the pop-up reminder "blink&quo...How can I make the pop-up reminder "blink" and "flash"? How can I change the colour to something much more vivid? ThanksArohainahttps://www.blogger.com/profile/07903368216007626559noreply@blogger.comtag:blogger.com,1999:blog-8170892423378293211.post-54161586217619520312012-08-21T17:00:08.058+01:002012-08-21T17:00:08.058+01:00This works great. FYI, at least in Outlook 2010, y...This works great. FYI, at least in Outlook 2010, you can change the "MsgBox..." line to "Application.ActiveExplorer.Activate" and it will just activate the Outlook reminder instead of creating a message box which you also have to close.Michael Shouphttps://www.blogger.com/profile/01018749780074721733noreply@blogger.com