Call External Data wizard through VB

Posted on 2011-04-20
Medium Priority
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
  • 3
  • 2
LVL 16

Expert Comment

ID: 35436149
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

ID: 35436172
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

Sheils earned 2000 total points
ID: 35436279
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

charlesguzman earned 0 total points
ID: 35436294
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

ID: 35458556
I found the answer on my own.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

850 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