Compare Access entry to Outlook address book

[Pastor Del]

My Access 2000 application emails a notification to the QA manager in
response to a specific event. Because the QA manger could change in the
future, the application allows for entering a new name. This new name must
match the name in our Outlook address book so the "To" argument of SendObject
method is correct and the email is successfully sent. The name is simply
entered in a text field. How can I compare this entry to names in an Outlook
address book?

 

[David H]

Although you're automating Outlook from within Access, this question would be
better asked in an Outlook dedicated newsgroup. I can tell you though that if
you're doing pretty much *anything* with the Outlook Address Book, that the
user *will* see a security warning that the OAB is being accessed. Its a
security thing. There is the possibility that Redemption can be used to
access the OAB without the security warnings, but I can't speak to that
(http://www.dimastr.com/redemption/rdo/default.htm).

http://www.microsoft.com/office/com...soft.public.outlook.program_vba&lang=en&cr=US

Also, keep in mind that because of the integration between Active Directory
and Exchange, you might be able to validate the email against Active
Directory as opposed to the Outlook Address Book.

http://joseph.randomnetworks.com/ar...ess-book-for-thunderbird-outlook-and-mailapp/

 

[JP]

In addition to David's suggestions, you can resolve the name by
calling the Recipients.ResolveAll method. If the name cannot be
resolved, you'll see a dialog box asking you to resolve it manually.
But that is only available in the Outlook object model, and will
trigger the security prompt.

--JP