Call External Data wizard through VB

Posted on 2011-04-20
Last Modified: 2012-06-27
How may I go about linking to Outlook's contacts with visual basic. Typically, I'd use the 'get external data' tab in the ribbon, but I want this to be a seamless process for my users where they can call up that import dialog with a command button rather than using the ribbon (the ribbon will be invisible in my program). Thank you so much for your time and help.

Question by:charlesguzman
    LVL 16

    Expert Comment

    You can import outlook contact list as a link table. Then the data from outlook contact list is available for use in your db

    Author Comment

    I know that I can link to Outlook contacts. I have a table called lstContacts already linked. My application is designed for a network, and each user's computer has different directories. By default, I would like to leave the outlook contacts table unlinked until the database is first installed on that machine.

    When the user starts up the database for the very first time, I would like the import data from outlook wizard to pop up, and I would like to do this with Visual Basic or a macro, which ever is easier.

    Thanks for your input.
    LVL 16

    Assisted Solution

    I am not sure how you will do that but also I can figure out why you should be going thought all this trouble.

    If your database is split into frontend/backend the link will already be established in the backend. Just installing the front end on individual desktop should work fine.

    I have a database on a network which is split in backend/frontend both of which are on the main drive. Then I add shortcut to the front end on each desktop and it works fine. This means that I only have one front end to worry about.

    Accepted Solution

    I have solved this problem. I'm wondering if it will work in the Access 2007 runtime environment. I decided to use the importattachoutlook function in an embedded macro to bring up the import window. Thanks for your help.

    Author Closing Comment

    I found the answer on my own.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now