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

Retrieve/list all my delegates and their permissions all at once



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 8th 06, 06:07 PM posted to microsoft.public.outlook.program_vba
whatamatch
external usenet poster
 
Posts: 1
Default Retrieve/list all my delegates and their permissions all at once

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  
Old September 8th 06, 11:30 PM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default Retrieve/list all my delegates and their permissions all at once

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
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
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


All times are GMT +1. The time now is 02:12 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.