We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Call External Data wizard through VB

charlesguzman
on
Medium Priority
331 Views
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.

Charlie
Comment
Watch Question

Commented:
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

Commented:
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.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I found the answer on my own.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.