Get data from Outlook Public Folders in Excel
 

Hello,

I have a piece of code that could retreive data from local outlook contacts
but I wish to get the data from a Public Folder. Does anybody know the right
code to get the data from the public folder?

Set OLF = GetObject("",
"Outlook.Application").GetNamespace("MAPI").GetFol der("Public Folders\All
Public Folders\A-contactpersonen")
If OLF Is Nothing Then Set OLF =
CreateObject("Outlook.Application").GetNamespace(" MAPI").GetFolder("Public
Folders\All Public Folders\A-contactpersonen") End If