Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. Public WithEvents GItems As Outlook.Items
  2. Private Sub Application_Startup()
  3. Set GItems = Outlook.Application.Session.GetDefaultFolder(olFolderInbox).Items
  4. End Sub
  5. Private Sub GItems_ItemAdd(ByVal Item As Object)
  6. Dim xMtRequest As MeetingItem
  7. Dim xAppointmentItem As AppointmentItem
  8. Dim xMtResponse As MeetingItem
  9. If Item.Class = olMeetingRequest Then
  10. Set xMtRequest = Item
  11. Set xAppointmentItem = xMtRequest.GetAssociatedAppointment(True)
  12. If xAppointmentItem.GetOrganizer.Name = "Sender Name" Then
  13. With xAppointmentItem
  14. .ReminderMinutesBeforeStart = 45
  15. .Categories = "Orange Category"
  16. .Save
  17. End With
  18. Set xMtResponse = xAppointmentItem.Respond(olMeetingAccepted, True)
  19. xMtResponse.Send
  20. xMtRequest.Delete
  21. End If
  22. End If
  23. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement