Select From Outlook Contacts

[XLEAccessGuru]

Hello everyone! Does anyone have any code snippets that will pull up the outlook address book from an access form and insert the selected contact(s) into the "To" text box I have on my form?

Any help appreciated!!!

 

[vodafrog]

Access 2002 onwards has the ability to link or import your Outlook Contacts folder directly, use the get External data, Link table, select Outlook contacts.

You can then use this table as the datasource to a listbox, and then allow multiselect. As each contact is selected, append the email address to your to field on your form, this would need code in order to do this.

alternatively you will need to use the Outlook Object Library, you will need to add this as a reference in your VBA code section, and use it methods and properties to access the contacts folder, etc.