Reading duration info from private appointments?

[JimAnAmateur]

Anybody has found solution to read duration (start, end) data from other
users' private appointments in Outlook using VBA?

I am writing a VBA (in Excel) which is supposed to make a summary/overview
of all appointments that a group of people have for a specific day (for use
at a "telephone switchboard"). It works fine, except for private
appointments that people may have in their calendars.
myNamespace.GetSharedDefaultFolder seems "ignoring" private appointments in
shared calendars (of course ok with the private appointments of the user who
is running the macro, but not the others' private appointments).

I've been searching on the Internet, the answers I found so far said "no,
it's not possible since a private appointment is a private appointment". Why
is it then possible in Outlook to view graphically "placeholders" of other
users' private appointments? There must be a way of achieving some data
about such appointments. I don't need details, but only "placeholders",
i.e., if there is an appointment, and what is the start time and duration.

Anybody who has solved this?

Regards
Jim

 

[Sue Mosher [MVP-Outlook]]

Use the Recipient.FreeBusy method. That approach is also likely to be much
faster overall than reading the full appointments.