asked on

Call External Data wizard through VB

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.

Charlie

Sheils

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

charlesguzman

ASKER

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.

SOLUTION

Sheils

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

charlesguzman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

charlesguzman

ASKER

I found the answer on my own.