Shared Calendar Owner's Name

Paparazzo · Joined: 20 Feb 2008 Posts: 2

Is there any way of extracting a user (owner) name from a displayed
appointment item from a shared calendar?

What I am trying to do is as follows:

Double click on a visible shared Calendar (e.g. that of “Wilson, Dan
(Accounts)”

This gives an Explorer item (“Untitled - Event”).

I use the NewExplorer event to display a toolbar which has a button to
insert the necessary data in the appointment item, and then save it.

A Word document is then created for issue to the client, but I need to
insert the person’s name (i.e. the "owner" of the Calendar, in this case Dan
Wilson) into the letter, but I can’t figure out how to actually get the name.

--
Paparazzo

Archived from group: microsoft>public>outlook>program_vba

Ken Slovak - [MVP - Outlo · Joined: 12 Aug 2007 Posts: 405

What version of Outlook?

If the store is a PST file then the owner is always whoever has it open at
that time. For an Exchange mailbox you need to get the Store property and
look at property PR_USER_NAME (0x661A001E), a PT_STRING8 value.

If this is Outlook 2007 you can use the new Store object and the
PropertyAccessor to read that property value. The DASL syntax for that
property would be "http://schemas.microsoft.com/mapi/proptag/0x661A001E".

You can also use the PR_MAILBOX_OWNER_NAME property (0x661C001E), another
PT_STRING8 property, the DASL for that is
"http://schemas.microsoft.com/mapi/proptag/0x661C001E".

If you are using an older version of Outlook you'd have to use a different
API such as CDO 1.21 (not supported for managed code) or Extended MAPI (C++
or Delphi only, not supported for managed code) or a 3rd party library such
as Redemption (www.dimastr.com/redemption).

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

"Paparazzo" wrote in message @microsoft.com...
> Is there any way of extracting a user (owner) name from a displayed
> appointment item from a shared calendar?
>
> What I am trying to do is as follows:
>
> Double click on a visible shared Calendar (e.g. that of “Wilson, Dan
> (Accounts)”
>
> This gives an Explorer item (“Untitled - Event”).
>
> I use the NewExplorer event to display a toolbar which has a button to
> insert the necessary data in the appointment item, and then save it.
>
> A Word document is then created for issue to the client, but I need to
> insert the person’s name (i.e. the "owner" of the Calendar, in this case
> Dan
> Wilson) into the letter, but I can’t figure out how to actually get the
> name.
>
> --
> Paparazzo

Paparazzo · Joined: 20 Feb 2008 Posts: 2

Ken

I'm using Outlook 2003 and due to network restrictions any possible solution
has to be done using VBA only.
--
Paparazzo

"Ken Slovak - [MVP - Outlook]" wrote:

> What version of Outlook?
>
> If the store is a PST file then the owner is always whoever has it open at
> that time. For an Exchange mailbox you need to get the Store property and
> look at property PR_USER_NAME (0x661A001E), a PT_STRING8 value.
>
> If this is Outlook 2007 you can use the new Store object and the
> PropertyAccessor to read that property value. The DASL syntax for that
> property would be "http://schemas.microsoft.com/mapi/proptag/0x661A001E".
>
> You can also use the PR_MAILBOX_OWNER_NAME property (0x661C001E), another
> PT_STRING8 property, the DASL for that is
> "http://schemas.microsoft.com/mapi/proptag/0x661C001E".
>
> If you are using an older version of Outlook you'd have to use a different
> API such as CDO 1.21 (not supported for managed code) or Extended MAPI (C++
> or Delphi only, not supported for managed code) or a 3rd party library such
> as Redemption (www.dimastr.com/redemption).
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007
> Reminder Manager, Extended Reminders, Attachment Options
> http://www.slovaktech.com/products.htm
>
>
> "Paparazzo" wrote in message
> @microsoft.com...
> > Is there any way of extracting a user (owner) name from a displayed
> > appointment item from a shared calendar?
> >
> > What I am trying to do is as follows:
> >
> > Double click on a visible shared Calendar (e.g. that of “Wilson, Dan
> > (Accounts)”
> >
> > This gives an Explorer item (“Untitled - Event”).
> >
> > I use the NewExplorer event to display a toolbar which has a button to
> > insert the necessary data in the appointment item, and then save it.
> >
> > A Word document is then created for issue to the client, but I need to
> > insert the person’s name (i.e. the "owner" of the Calendar, in this case
> > Dan
> > Wilson) into the letter, but I can’t figure out how to actually get the
> > name.
> >
> > --
> > Paparazzo
>
>

Ken Slovak - [MVP - Outlo · Joined: 12 Aug 2007 Posts: 405

Then your options are CDO 1.21 or a 3rd party library, as mentioned before.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

"Paparazzo" wrote in message @microsoft.com...
> Ken
>
> I'm using Outlook 2003 and due to network restrictions any possible
> solution
> has to be done using VBA only.
> --
> Paparazzo

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

Ken, do you know if PR_MAILBOX_OWNER_NAME works for both types of shared folders -- a) those opened through a secondary mailbox set up in the profile settings and b) those opened with File | Open | Other User's Folder or shared with Outlook 2007 sharing items? Thanks!

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Ken Slovak - [MVP - Outlook]" wrote in message news:%23sHL8$8cIHA.1132@TK2MSFTNGP06.phx.gbl...
> What version of Outlook?
>
> If the store is a PST file then the owner is always whoever has it open at
> that time. For an Exchange mailbox you need to get the Store property and
> look at property PR_USER_NAME (0x661A001E), a PT_STRING8 value.
>
> If this is Outlook 2007 you can use the new Store object and the
> PropertyAccessor to read that property value. The DASL syntax for that
> property would be "http://schemas.microsoft.com/mapi/proptag/0x661A001E".
>
> You can also use the PR_MAILBOX_OWNER_NAME property (0x661C001E), another
> PT_STRING8 property, the DASL for that is
> "http://schemas.microsoft.com/mapi/proptag/0x661C001E".
>
> If you are using an older version of Outlook you'd have to use a different
> API such as CDO 1.21 (not supported for managed code) or Extended MAPI (C++
> or Delphi only, not supported for managed code) or a 3rd party library such
> as Redemption (www.dimastr.com/redemption).
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007
> Reminder Manager, Extended Reminders, Attachment Options
> http://www.slovaktech.com/products.htm
>
>
> "Paparazzo" wrote in message
> @microsoft.com...
>> Is there any way of extracting a user (owner) name from a displayed
>> appointment item from a shared calendar?
>>
>> What I am trying to do is as follows:
>>
>> Double click on a visible shared Calendar (e.g. that of “Wilson, Dan
>> (Accounts)”
>>
>> This gives an Explorer item (“Untitled - Event”).
>>
>> I use the NewExplorer event to display a toolbar which has a button to
>> insert the necessary data in the appointment item, and then save it.
>>
>> A Word document is then created for issue to the client, but I need to
>> insert the person’s name (i.e. the "owner" of the Calendar, in this case
>> Dan
>> Wilson) into the letter, but I can’t figure out how to actually get the
>> name.
>>
>> --
>> Paparazzo
>

Ken Slovak - [MVP - Outlo · Joined: 12 Aug 2007 Posts: 405

Sue,

I didn't try with the OL12 sharing items but using File, Open, Other etc.
didn't show either property in OutlookSpy. In my experience opening a folder
that way doesn't provide many of the properties you need for various things.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

"Sue Mosher [MVP-Outlook]" wrote in message @TK2MSFTNGP05.phx.gbl...
Ken, do you know if PR_MAILBOX_OWNER_NAME works for both types of shared
folders -- a) those opened through a secondary mailbox set up in the profile
settings and b) those opened with File | Open | Other User's Folder or
shared with Outlook 2007 sharing items? Thanks!

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Default Shared Journal Folder We have a Customer Management product which synchronises a number of different accounting and POS systems to custom OL Contact forms. This has been fine for 1-2 users. However, we need to make this available for multiple users, enabling them to access a c

Calendar Event Hello All, I'm trying to do the following: I want to be able to trap a new appointment BEFORE it gets saved (after user selects save). The point is to be able to add some logic to what can go in a calendar. The Outlook object model doesn't appear to have

How to send calendar appointment or meeting request using .N How to send outlook calendar appointment or meeting request using .Net classes or assemblies?

Help! putting dates from access into PUBLIC calendar, at the moment i am exporting some dates into an appointment from access using a command button which does this --- Private Sub On Error GoTo Add_Err 'Save record first to be sure required fields are filled. acCmdSaveRec

Appointment in Calendar help - Event triggers - Visual basic I've added an event handler to trigger when a new appointment is added into my calendar. This works. However, when a new appointment is viewed in a preview pane in an inbox folder, this event is also triggered as Outlook appears to move a 'tentative' appo