• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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
0
charlesguzman
Asked:
charlesguzman
  • 3
  • 2
2 Solutions
 
SheilsCommented:
You can import outlook contact list as a link table. Then the data from outlook contact list is available for use in your db
0
 
charlesguzmanAuthor 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.
0
 
SheilsCommented:
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.
0
 
charlesguzmanAuthor Commented:
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.
0
 
charlesguzmanAuthor Commented:
I found the answer on my own.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now