Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

Microsoft Outlook 2010 Reminders

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
bidgadget
Asked:
bidgadget
  • 2
1 Solution
 
David LeeCommented:
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
 
bidgadgetAuthor Commented:
very acceptable.  Thank you
0
 
David LeeCommented:
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now