MS Outlooks address book

[Ken OHanlon]

How do you get MS Outlooks address book(contacts) to fill an Access 2003 combo box? Thanks-Ken.

[maxamis4]

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_email_access_outlook.htm

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

In Access, click the New Table button to add a new table. 
In the New Table dialog, choose Link Table, then click OK. 
In the Link dialog, under Files of type, choose Outlook() or Exchange(). 
If you're prompted for an Outlook profile, indicate which one you want to use 
In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next. 
Give the linked table a name, then click Finish.

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeoutlookhowto.htm

[Ken OHanlon]

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_email_access_outlook.htm

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

In Access, click the New Table button to add a new table. 
In the New Table dialog, choose Link Table, then click OK. 
In the Link dialog, under Files of type, choose Outlook() or Exchange(). 
If you're prompted for an Outlook profile, indicate which one you want to use 
In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next. 
Give the linked table a name, then click Finish.

http://www.kayodeok.btinternet.co.uk...tlookhowto.htm

I looked at the "www.bluecl aw" web page but no where is there a " VB+Outlook reference library" choice to lookup. Were is it? Thanks -Ken.

[maxamis4]

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.

[Ken OHanlon]

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.Applica tion" 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.