View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wim VR[_2_] Wim VR[_2_] is offline
external usenet poster
 
Posts: 4
Default 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