So close... yet so far. Access / Outlook help

[Autoeng]

I need some help with my integration of the Outlook global address book into Access. I know that I can link to the Outlook address book but this is not what I want to do so let's not go there. I have figured out vba to get the address book open on a button click and even pass the info to the fields that I want but I am getting a message from Outlook that I want to eliminate. I have attached a zipped example db and word file with the message. If anyone has any suggestions I would appreciate it.



Autoeng

 

[Drevlin]

Ok, just by sheer coincidence I actually found this website. It allows you to download a COM object that they call Redemption. What redemption does is allow you to connect to Outlook by-passing the Security patch.
It even gives an example on how to access the Contacts and print out each of the contacts email addresses without giving you the security pop-up.

Very cool stuff.

The website says its free to download unless you use it to make money. I've tested it... had a bit o' a time figuring out how to get where I wanted it to go, but it seems to work. Give it a shot:

http://www.dimastr.com/redemption/

Enjoy.