Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Access: Export Data to Outlook Address Book

  • 12-09-2003 10:52AM
    #1
    the Guru
    Closed Accounts Posts: 1,362 ✭✭✭


    Hi Guys I have a ACCESS data base and I want to Export all the Details so that it populates in to Outlook Address Book

    Does any one know if this can be done or how can i do it.


Comments

  • #2
    Mr E
    Registered Users, Registered Users 2 Posts: 55,780 ✭✭✭✭Mr E


    Export the access table as a CSV, and import it into outlook. (Should work!)

    - Dave.


  • #3
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 97,532 Mod ✭✭✭✭Capt'n Midnight


    First go into outlook and make a contact and fill in the fields you will use. Next - File - import/export and choose excel or csv.

    Next do the export form access to execl.

    Now you have to change field names to match the outlook ones and then do the import in Outlook

    Notes: Outlook / OE / Exchange use different names for the same fields -

    Exchange and Outlook with Exchange as default delivery service may export addresses in X400 format not smtp
    (You have to export the contacts to address book and then import them in OE and export again to get smtp format.)

    So if you are doing a lot of cross importing then generate a FAKE address with the fields of the other program .. then in Excel you move this line to the top so it now contains the field names.


    It's a trivial problem - made complex by M$'s consisitant reluctance to adhere to thier own standards/conventions.


Advertisement
Advertisement