is it possible to use an outlook distribution list as a workgroup?

M

martinmike2

sorry, i ment Is it possible to use an outlook distribution list to
fill a workgroup for access.
 
D

Danny Lesandrini

So this is a 2-part code solution:

1) Find/Read and Loop through Outlook Distribution File
2) Build members of a Workgroup from the list.

I believe this can be done. I'll have to look back in my code libraries for
example code. Maybe someone can point you to the code to add users to
workgroups. I'll look for the code to peek into distribution lists.
 
D

Douglas J. Steele

Just a warning to martinmike2. Note that whatever solution is possible will
not be dynamic. Adding or removing members from the Outlook group will NOT
be automatically reflected in the Workgroup. You may want to reconsider if
this is a good idea.
 
M

martinmike2

Just a warning to martinmike2. Note that whatever solution is possible will
not be dynamic. Adding or removing members from the Outlook group will NOT
be automatically reflected in the Workgroup. You may want to reconsider if
this is a good idea.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)








- Show quoted text -
Click to expand...

hmm..... let me guess, Access and Outlook wont talk to each other in
this way..........if this is so then ill just have to stop being lazy
and do the work, lol.
 
D

Danny Lesandrini

I couldn't find my code for adding users to a Workgroup, but a newsgroup
post search turned up this code for loopin through lists and contacts.
Problem is that new outlook security issues prevent access. You'd have to
also implement Redemption code, unless you just run this once for an initial
load.

Here's code I found from Doug Haigh. He said there was an issue with it,
but I was able to run it and output lists and contact names to the debug
window. It will take some work to adapt, but it will work.

Danny


Function foo()
Dim ol As New Outlook.Application
Dim ns As Outlook.NameSpace
Dim newMail As MailItem
Set ns = ol.GetNamespace("MAPI")
ns.Logon , , False, True

Dim aPAB() As Variant
Dim adl As Outlook.AddressList
Dim dl As Outlook.AddressEntry
Dim ae As Outlook.AddressEntry
Dim dle As Outlook.AddressEntries
Dim i As Integer
ReDim aPAB(100, 2)
Set ns = ol.GetNamespace("MAPI") 'Return the personal address book.

For Each adl In ns.AddressLists
Debug.Print "Address list name is " & adl.Name
If adl.Name = "Contacts" Then
Debug.Print "There are " & adl.AddressEntries.Count & " entries in
this list."
For Each dl In adl.AddressEntries
Debug.Print "Entry #" & i & " is " & dl.Name & " of type " &
dl.Type & " display type " & dl.DisplayType

i = i + 1
If dl.Type = "MAPIPDL" Then
'
' NOTE: The following line works just fine and I see the
Entries
'
dl.Details
'
' NOTE: The following line produces a COM error
'
Debug.Print "There are " & dl.Members.Count & " entries in
the list"
End If
Next
End If
Next

End Function
 
D

Douglas J. Steele

Access doesn't talk to anyone for this. <g>

Many people have also asked about integrated Access User-Level Security with
Active Directory, and active integration just isn't possible.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


- Show quoted text -

hmm..... let me guess, Access and Outlook wont talk to each other in
this way..........if this is so then ill just have to stop being lazy
and do the work, lol.
 
A

a a r o n . k e m p f

yah, in other words-- if you want to do this, then you NEED to use SQL
Server and the default 'INTEGRATED SECURITY'

note that the Access 2007 doesn't even _SUPPORT_ANY_JET_SECURITY_ so
yah-- if you want to use Access and you want Active-Directory
security.. you need to upsize to SQL Server (and Access Data
Projects).
 
T

Tony Toews [MVP]

note that the Access 2007 doesn't even _SUPPORT_ANY_JET_SECURITY_
Click to expand...

This is wrong. A2007 supports ULS if the file is in MDB format.
Not in ACCDB format.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
A

a a r o n . k e m p f

like I said-- Access 2007 (format) doesn't include ULS. Because it is
too buggy for real world usage, Microsoft has been reccomending for a
decade-- to move to SQL Server if you have _ANY_ security
requirements.

I don't need to put (format) all over the place. Access 2007 doesn't
support replication nor ULS.

-Aaron
 
Top