Many people desire that Outlook can auto accept specific meeting invitations, like invitations from specific organizers. Some users also hope that Outlook is able to auto update the reminder as per their own habits. This article will tell how to quickly accomplish it with Outlook VBA.
When you want to create a rule to auto accept specific meeting invitations, you’ll find that you can only set the conditions, such as meeting requests from specific people, but there is no action to accept them. It means that you cannot achieve it via Outlook rule. In addition, the meeting invitations may come with the preset reminder by the organizer. Perhaps you have your own preferred reminder time. In response to the two requirements, you can realize them simply with Outlook VBA. Here are the concrete VBA codes and elaborate steps.
Auto Accept Specific Meeting Invitations and Update the Meeting Reminder
- In the first place, start Outlook application and head to “Developer” tab.
- Then you should click “Visual Basic” button.
- In the new screen of “Microsoft Visual Basic for Applications”, you need open “ThisOutlookSession” project and copy the following codes into it.
Public WithEvents olItems As Outlook.Items Private Sub Application_Startup() Set olItems = Outlook.Application.Session.GetDefaultFolder(olFolderInbox).Items End Sub Private Sub olItems_ItemAdd(ByVal Item As Object) Dim olMtRequest As MeetingItem Dim olMtAppt As AppointmentItem Dim olMtResponse As MeetingItem If TypeName(Item) = "MeetingItem" Then Set olMtRequest = Item 'Get the corresponding appointment in your calendar Set olMtAppt = olMtRequest.GetAssociatedAppointment(True) 'Check meeting organizer and its date If olMtAppt.Organizer = "specific person name" Then If WeekdayName(Weekday(olMtAppt.Start)) <> "specific day" Then With olMtAppt 'Replace "45" with your desired reminder time .ReminderMinutesBeforeStart = 45 'Set a specific category .Categories = "specific category name" .Save End With 'Accept and then delete the meeting request Set olMtResponse = olMtAppt.Respond(olMeetingAccepted) olMtResponse.Send olMtRequest.Delete End If End If End If End Sub
- After that, you should create a new digital certificate and assign it to the new code.
- Subsequently, you can exit the “Visual Basic” window and change the macro settings to permit digitally signed macros only.
- Thereafter, when you get the meeting invitation from the specific organizer and not occurred on the specific day, Outlook will automatically accept it and send a response. And then it will auto update the reminder of the meeting in your calendar as per your preset minute in codes.
Watch out for Harmful Factors to Outlook
Outlook data is vulnerable to many factors, such as viruses, malware and power outage and so on. Therefore, it is vitally important to keep vigilant against them. Otherwise, you will push your Outlook at risk. Of course, if you have a good habit of making regular backups, you can easily recover corrupt Outlook file. But if you have no backups in place, you would be required to take recourse to a robust tool, like DataNumen Outlook Repair.
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair corrupted SQL and outlook repair software products. For more information visit www.datanumen.com