Solved

Microsoft Outlook 2010 Reminders

Posted on 2014-03-17
3
395 Views
Last Modified: 2014-03-20
I have a user complaining he keeps getting reminders.  They get a lot of invitations but they do not respond because they are for informational purposes.  So my question is

Is there a way to disable reminders on calendar entries that have not been accepted?

Thank you
0
Comment
Question by:bidgadget
  • 2
3 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 39936420
Hi, bidgadget.

I can manage that with a bit of scripting.  If that's an acceptable approach, then let me know and I'll post the code and instructions on how to use it.
0
 

Author Comment

by:bidgadget
ID: 39940821
very acceptable.  Thank you
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 39941894
You're welcome.

Here's my solution.  It reads through the currently selected calendar and checks each entry to see if the ResponseStatus property is set to "not responded".  If it is, and if the item is a meeting (as opposed to an appointment the user created), then the item's reminder is cleared.  

Follow these instructions to use this solution.

1.  Start Outlook
2.  Press ALT+F11 to open the Visual Basic editor
3.  If not already expanded, expand Microsoft Office Outlook Objects
4.  If not already expanded, expand Modules
5.  Select an existing module (e.g. Module1) by double-clicking on it or create a new module by right-clicking Modules and selecting Insert -> Module.
6.  Copy the code from the Code Snippet box and paste it into the right-hand pane of Outlook's VB Editor window
7.  Edit the code as needed.  I included comments wherever something needs to or can change
8.  Click the diskette icon on the toolbar to save the changes
9.  Close the VB Editor

Sub KillReminders()
    Const MACRO_NAME = "Kill Reminders"
    Dim olkFld As Outlook.MAPIFolder, olkApt As Outlook.AppointmentItem, lngCnt As Long
    Set olkFld = Application.ActiveExplorer.CurrentFolder
    If olkFld.DefaultItemType = olAppointmentItem Then
        For Each olkApt In olkFld.Items
            Select Case olkApt.ResponseStatus
                'If you want to clear the reminders on tentatively accepted appointments, then add olResponseTentative to the next line.
                Case olResponseNotResponded
                    If olkApt.MeetingStatus = olMeeting Then
                        olkApt.ReminderSet = False
                        olkApt.Save
                        lngCnt = lngCnt + 1
                    End If
            End Select
        Next
        MsgBox "Processing complete.  I cleared reminders on " & lngCnt & " items.", vbInformation + vbOKOnly, MACRO_NAME
    Else
        MsgBox "This macro only works when you have a calendar selected.  Please select a calendar, then run the macro.", vbCritical + vbOKOnly, MACRO_NAME
    End If
End Sub

Open in new window


To use this solution

1.  Select a calendar
2.  Run the macro KillReminders
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

777 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