Extract field values from calendar meeting form

[lorenmcguire]

I have developed a specific form to put data into a group calendar. I have
also developed an excel spreadsheet to extract this information from the
calendar and put it into a spreasheet. Some of the information is older,
made with the original Appointment form designed for the Calendar. Other
information is in a "Meeting" type form on the Calendar. I have attempted
to extract the Start and End dates from the "Meeting" form, but don't appear
to have the correct field or data type information. I can pull the Start and
End Values by using:

MsgBox "itm.Start Value is: " & itm.Start
MsgBox "itm.End Value is: " & itm.End

along with:

MsgBox "itm.CreationTime is " & itm.CreationTime
MsgBox "itm.Subject is " & itm.Subject

The "itm.CreationTime" appears to be universal among the various forms,
including the Appointment and Meeting forms, but the "itm.Start" and
"itm.End" values do nothing. Does anyone know how to pull this information,
and other information on the Meeting Form such as:

Organizer
Location
Sent
Label
Message Body

from the Meeting Form?

Thanks,

 

[Sue Mosher [MVP-Outlook]]

To get the appointment details from a meeting request, you can use the MeetingItem.GetAssociatedAppointment method to return the actual appointment.