A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Calendar private appointments, an unresolved question...



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 23rd 09, 04:55 PM posted to microsoft.public.outlook.program_vba
Alberto_5015
external usenet poster
 
Posts: 2
Default Calendar private appointments, an unresolved question...

In Outlook 2003's calendar view you can see a placeholder for a private
appointment in another person's calendar.

There is a way to retrive non-confidential information (start, end and
free/busy status) by vba or it is impossible???

Thanks in advance,
Alberto
Ads
  #2  
Old July 2nd 09, 01:42 PM posted to microsoft.public.outlook.program_vba
Alan Moseley
external usenet poster
 
Posts: 61
Default Calendar private appointments, an unresolved question...

You need to use the GetFreeBusy method of the AddressEntry object to do this.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Alberto_5015" wrote:

In Outlook 2003's calendar view you can see a placeholder for a private
appointment in another person's calendar.

There is a way to retrive non-confidential information (start, end and
free/busy status) by vba or it is impossible???

Thanks in advance,
Alberto

  #3  
Old July 7th 09, 01:41 PM posted to microsoft.public.outlook.program_vba
Alberto_5015
external usenet poster
 
Posts: 2
Default Calendar private appointments, an unresolved question...

Hi Alan, thanks for the hint!

I'm trying to do some experiments with the the GetFreeBusy method,
but it seems a little unpredictable...
Sometimes I got the right day and hour of an hidden appointment,
but sometime they are wrong!

And how can I find the end of the appointment???

Can anyone post a little example?

Thanks in advance,
Alberto



"Alan Moseley" wrote:

You need to use the GetFreeBusy method of the AddressEntry object to do this.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Alberto_5015" wrote:

In Outlook 2003's calendar view you can see a placeholder for a private
appointment in another person's calendar.

There is a way to retrive non-confidential information (start, end and
free/busy status) by vba or it is impossible???

Thanks in advance,
Alberto

  #4  
Old July 7th 09, 02:11 PM posted to microsoft.public.outlook.program_vba
Alan Moseley
external usenet poster
 
Posts: 61
Default Calendar private appointments, an unresolved question...

GetFreeBusy does not get the start and end times of appointments as you have
probably figured out. If a user has created an appointment in their
calendar, it will detect whether they have set the 'Show Time As' box to free
or busy. If the user has not done this then the method will not return the
information that you are expecting. Some sample code:-

Public Function GetFreeBusyOfSomeone(Person As String) As String
Dim objRecipient As Recipient
Dim objAddressEntry As AddressEntry
Dim strFreeBusy As String

Set objRecipient = Outlook.Session.CreateRecipient(Person)
objRecipient.Resolve
If objRecipient.Resolved Then
Set objAddressEntry = objRecipient.AddressEntry
strFreeBusy = objAddressEntry.GetFreeBusy(#7/7/2009#, 60)
Set objAddressEntry = Nothing
End If
Set objRecipient = Nothing
GetFreeBusyOfSomeone=strFreeBusy
End Sub

This gets a string showing Fred Bloggs free or busy status starting on the
7th July in 60 minute intervals for the next 30 days. Therefore if the first
character in the string is a 0 then the person is free from 00:00 till 01:00.
If it is a 1 then the person is marked as busy from 00:00 to 01:00, and so
on.

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Alberto_5015" wrote:

Hi Alan, thanks for the hint!

I'm trying to do some experiments with the the GetFreeBusy method,
but it seems a little unpredictable...
Sometimes I got the right day and hour of an hidden appointment,
but sometime they are wrong!

And how can I find the end of the appointment???

Can anyone post a little example?

Thanks in advance,
Alberto



"Alan Moseley" wrote:

You need to use the GetFreeBusy method of the AddressEntry object to do this.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Alberto_5015" wrote:

In Outlook 2003's calendar view you can see a placeholder for a private
appointment in another person's calendar.

There is a way to retrive non-confidential information (start, end and
free/busy status) by vba or it is impossible???

Thanks in advance,
Alberto

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to set all previous appointments private on calendar Make all previous appointments private? Outlook - Calandaring 2 September 18th 09 02:35 AM
How can I open private appointments on a shared calendar? Mauilady3 Outlook - Calandaring 1 April 23rd 09 12:22 AM
Print a calendar that only shows private appointments Slicer49 Outlook - Calandaring 2 April 2nd 09 11:01 PM
private appontment on a shared calendar question Dave Taylor Outlook - Calandaring 0 April 4th 08 07:44 PM
Private appointments in calendar Calendar Girl Outlook - Calandaring 4 March 31st 06 11:32 AM


All times are GMT +1. The time now is 05:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.