Reading duration info from private appointments?

J

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
 
S

Sue Mosher [MVP-Outlook]

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top