![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
Hi,
Is it possible to retrieve/list all my delegates and their permissions at once using vba/vbs? For example, could I extract all the information and publish in Excel? I am not sure if VBA would allow me to do this, OR there are some other ways? Thanks in advance! |
#2
|
|||
|
|||
![]()
On the Extended MAPI level (can't do that in VBA or even VB), you will need
to open the PR_EMS_AB_PUBLIC_DELEGATES property is IMAPITable, then reads it rows. Outlook Object Model or CDO 1.21 do not expose this functionality. plug Redemption exposes that list through the RDOAddressEntry.Delegates collection. The sample script below resolves a name against GAL and prints out the names of all the delegates. In your case you probably need to replace the line set AddressEntry = Session.AddressBook.GAL.ResolveName("dmitry") with set AddressEntry = Session.CurrentUser to access the current user (you) as RDOAddressEntry object. set Session = CreateObject("Redemption.RDOSession") Session.MAPIOBJECT = Application.Session.MAPIOBJECT 'Outlook 2002 and up set AddressEntry = Session.AddressBook.GAL.ResolveName("dmitry") Debug.Print "-- Delegates (who can send of behalf of " & AddressEntry.Name & ")" for each AE in AddressEntry.Delegates Debug.Print AE.Name next /plug Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool "whatamatch" wrote in message ... Hi, Is it possible to retrieve/list all my delegates and their permissions at once using vba/vbs? For example, could I extract all the information and publish in Excel? I am not sure if VBA would allow me to do this, OR there are some other ways? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Organizational Froms Library Permissions error, but I have permissions? | Trigon | Outlook - Using Forms | 11 | February 1st 07 01:49 AM |
Access permissions on folder. Owner cannot grant permissions | lmeyer | Outlook - Installation | 0 | June 14th 06 12:06 PM |
Delegates | MichaelJ | Outlook - General Queries | 1 | May 16th 06 03:51 PM |
list of Delegates from Outlook | Abhi Sharma | Outlook - Calandaring | 5 | April 19th 06 04:19 PM |
Calendar Delegates | Chris Z. | Outlook - Installation | 0 | January 31st 06 02:19 PM |