Outlook Automation Hanging On Address Book

[Soule]

My environment is:
- Access 2007
- .accdb file
- Button code in standard module (for debugging; will move to form class mod. when works)
- Am in datasheet view when compiling/stepping through/running
- Early binding w/Intellisense
- Libraries (in this order):
VB for Apps
MS Access 12.0 Obj. Lib.
MS Outlook 12.0 Obj. Lib.


MS OFC 12.0 Access db engine Obj. Lib.
MS VB for Apps Extensibility 5.3
MS VBScript Regular Expressions 5.5
MS ActiveX Data Objects 2.8 Lib.
OLE Automation
- No compile or run-time errors

Hi, Everyone,

I'm trying to send an automated e-mail from Access through Outlook with a form button click. (My code runs whether my instance of Outlook is visible or not.)

When stepping through my code's "send" statement fires, the Microsoft Office Outlook security warning fires ("A program is trying to send an e-mail message on your behalf...etc..), which is fine. I don't mind my users having to click that. When I click the "Allow" button to continue, Outlook's "Check Names" dialogue box comes up. I then click "Show More Names" which brings up the company's global address list. I find my name, select it, click "OK". My code drops down to my error handling line.

Has anyone had this or a similar problem with addressess using Outlook automation?

Is it a problem with permissions at IT level? A certificate, perhaps?

Any ideas will help. Thanks for reading this!

Frank

This post is also here: http://www.utteraccess.com/forum/Out...l#entry2213861 and http://www.access-programmers.co.uk/...12#post1135612 and http://bytes.com/topic/visual-basic/...ok#post3705302

[June7]

Post your code for analysis.

So far, this is the only thing I have found http://www.pcreview.co.uk/forums/usi...-t3625055.html

The code will open the addressbook search dialog but as the thread states, must click Outlook to bring it forward. Then it does return addressee to the procedure. I incorporated this into my send procedure and it worked. Haven't figured out the Win API calls to get the dialog forward.

[Soule]

Hi, again, June!

Thank you for taking the time to consider this problem.

After I click "Allow" on the Outlook security dialog that pops up after my send statement runs, the company's global address book pops up fine in the form of the "Check Names" dialog box. My problem is that it is not recognizing names that are in it. Because the Outlook security dialog box was activated, I think it might be a problem that can only be solved with a permission change through my IT. I'm checking it out and will let you guys know what the solution was in another reply. Thanks for caring!

Frank

[Soule]

Hi, June,

This problem just magically fixed itself. All of a sudden my server requests were going through. I don't know what happened, but I hope it doesn't stop. Ha ha!

Thanks.