Update an Outlook Appointment

  • Thread starter Thread starter Legacy 128378
  • Start date Start date
L

Legacy 128378

Guest
I am trying to find and then change the categories from Acitve to Cancelled to chaned the appointment color from green to red. The code I am using to create the appointment works great but I cannot get the code to change the appointment to work. Below is the code that contiues to error.

Thanks!

Private Sub UpdateAppt_Click()
Dim olook As New Outlook.Application
Dim olookns As Outlook.NameSpace
Dim CalItem As Outlook.MAPIFolder
Dim ApptItem As Outlook.AppointmentItem
Set olookns = olook.GetNamespace("MAPI")
Set CalItem = olookns.GetDefaultFolder(olFolderCalendar)
CalItem.Items.Sort ("[Start]")

Set ApptItem = CalItem.Items.Find("[Subject] = """ & Me!ID & """")
If Appointment.Categories = Active Then
With ApptItem
.Categories = Cancelled
If objAppt Is Nothing Then
MsgBox "appointment not found"
End If
.Save
Set Appointment = Nothing
Set oOutlook = Nothing
End With
Set objOutlook = Nothing
Exit Sub
End Sub

 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,224,616
Messages
6,179,912
Members
452,949
Latest member
beartooth91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top