By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

MS Outlooks address book

P: 39
How do you get MS Outlooks address book(contacts) to fill an Access 2003 combo box? Thanks-Ken.
Apr 14 '08 #1
Share this Question
Share on Google+
4 Replies


maxamis4
Expert 100+
P: 295
You will need to lookup the VB+Outlook reference library. It will allow you to use outlook in Access.
example here
http://www.blueclaw-db.com/read_emai...ss_outlook.htm



Another way is this method but not recommended leaves to many blanks

Expand|Select|Wrap|Line Numbers
  1. In Access, click the New Table button to add a new table. 
  2. In the New Table dialog, choose Link Table, then click OK. 
  3. In the Link dialog, under Files of type, choose Outlook() or Exchange(). 
  4. If you're prompted for an Outlook profile, indicate which one you want to use 
  5. In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next. 
  6. Give the linked table a name, then click Finish.
  7.  
  8.  
http://www.kayodeok.btinternet.co.uk...tlookhowto.htm
Apr 15 '08 #2

P: 39
You will need to lookup the VB+Outlook reference library. It will allow you to use outlook in Access.
example here
http://www.blueclaw-db.com/read_emai...ss_outlook.htm



Another way is this method but not recommended leaves to many blanks

Expand|Select|Wrap|Line Numbers
  1. In Access, click the New Table button to add a new table. 
  2. In the New Table dialog, choose Link Table, then click OK. 
  3. In the Link dialog, under Files of type, choose Outlook() or Exchange(). 
  4. If you're prompted for an Outlook profile, indicate which one you want to use 
  5. In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next. 
  6. Give the linked table a name, then click Finish.
  7.  
  8.  
http://www.kayodeok.btinternet.co.uk...tlookhowto.htm

I looked at the "www.blueclaw" web page but no where is there a " VB+Outlook reference library" choice to lookup. Were is it? Thanks -Ken.
Apr 15 '08 #3

maxamis4
Expert 100+
P: 295
Well the object library is loaded in the access module view. go to tools reference and then look for the outlook reference library. Please note that once thats loaded you can use the blue claw code to setup your own outlook module.
Apr 17 '08 #4

P: 39
Well the object library is loaded in the access module view. go to tools reference and then look for the outlook reference library. Please note that once thats loaded you can use the blue claw code to setup your own outlook module.
I now understand the first part of your instructions! From the VB editor, select TOOLS, from TOOLS select REFERENCES. Inside REFERENCES select which? Theres a "Microsoft Office Outlook View Control" and a "Microsoft Office 11.0 Object Library". For fun I selected both.
Then I went to "blueclaw-db" using your link. I copied the code at the bottom of that page (Private Sub ReadInBox) into my .mdb to practice/understand. Well it will not even complie w/o giving an error on line "Dim OlApp As Outlook.Application" Besides, at this point isn't there just a "table" or whatever I should be able to access containing the Office Address Book? Need more help -Ken.
Apr 17 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.