Results 1 to 5 of 5
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Export Contacts from Public Folder (XP/SP1)

    We have 4800 contacts in the public folder. I would like to export to Excel. I cannot <font color=red>
    Alan

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Export Contacts from Public Folder (XP/SP1)

    See if you can see it via importing initially into Access. And you may need to have rights to the Public Contacts Folder, but one of the odd things is that in my corporation, I don't have rights to Public Folders through Outlook, but I can use Access to get at most information stores, including the GAL. (Keep it our little secret.) Open Access, start a new DB and name it, then use File I Get External Data I Import | Files of Type Exchange. It should open a dialog like the attached, from whence you should be able to expand and browse the Public Folders Tree (as I did partly in the graphic), drop the data into an Access table and re-export that table to Excel.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Export Contacts from Public Folder (XP/SP1)

    Some IT departments have the option blocked to prevent the copying, giving and selling of the list. You need to contact your IT department.

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  4. #4
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Export Contacts from Public Folder (XP/SP1)

    <big> <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>It looks like that is working. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    I'll keep the secret. </big>
    Alan

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Export Contacts from Public Folder (XP/SP1)

    See <!post=this,261471>this<!/post> thread, and thank Drew for the tip.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •