Posted to microsoft.public.excel.programming

Wim VR[_2_] Wim VR[_2_] is offline

external usenet poster

Posts: 4

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get contacts from Public folders into a userform	Oggy	Excel Discussion (Misc queries)	0	March 22nd 07 10:33 PM
Get contacts from Public folders into a userform	Oggy	Excel Programming	0	March 22nd 07 10:20 PM
Hyperlink to Outlook Public Folders	SueD	Links and Linking in Excel	0	January 18th 06 10:37 AM
Post to Public Folders	Maria K Brickl	Excel Programming	5	November 19th 04 02:45 AM
Linked Spreadsheets through Public Folders	Jim Bruce	Excel Programming	0	September 23rd 03 02:53 PM

All times are GMT +1. The time now is 06:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us