Get data from Outlook Public Folders in Excel

W

Wim VR

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").GetFolder("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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get outlook contacts from a Public folder instead of DefaultFolder 7
Creating Outlook Task from Excel 0
Excel vba macro to read Public folder in Outlook 4
Extract Outlook mail using VBA from non default Inbox 4
VSTO C# add in Outlook.Appointment error 0
ItemAdd and FolderAdd events problem with Public Folders 0
Synchronization problems while moving folders to new email 1
OLE Automation and Mutliple Office Releases 0

Top