To Import icalendar (*.ics) to calendar using Macro
After long time i am posting this blog. Although this information is not totally about peoplesoft someway we can relate it. Basically in peoplesoft we will send Appointment/Meeting request [which is in icalendar(.ics) format] as attachment in the mail. It won’t put an entry in Calendar unless u open the icalendar . it is a tough call for managers/executives who wont open the mail but they want an entry in Calendar. So i thought of doing this thru Macro. It works perfectly. I am not an Macro expert but this is quiet interesting. Thanks to Yogesh and Raja for giving Microsoft VBA tips :-) 'written by Vijay (psoftadmirer) Public Sub Moveicstocalendar() ' This Outlook macro checks at the Outlook Inbox for messages ' with attached files (of *.ics type) and put a entry in the calendar. On Error GoTo GetAttachments_err 'Declarations Dim outApp As Outlook.Application Dim InboxFolder As Outlook.MAPIFolder Dim myCalendarFolder As Outlook.MAPIFolder Dim ImportAppointmentitem As M