vba - Auto run when an appointment is updated -
i automatically run macro when appointment updated.
for test, wish macro displays subject of appointment.
you want itemchange event http://msdn.microsoft.com/en-us/library/office/ff865866%28v=office.14%29.aspx
public withevents myolitems outlook.items public sub application_startup() set myolitems = _ application.getnamespace("mapi").getdefaultfolder(olfoldercalendar).items end sub private sub myolitems_itemchange(byval item object) debug.print item.subject end sub
Comments
Post a Comment