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/Outlook-Automation-Hangin-t1982925.html and http://www.accessforums.net/showthr...n-Hanging-On-Address-Book?p=106611#post106611 and http://bytes.com/topic/visual-basic...k-automation-hanging-address-book#post3705302
- 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/Outlook-Automation-Hangin-t1982925.html and http://www.accessforums.net/showthr...n-Hanging-On-Address-Book?p=106611#post106611 and http://bytes.com/topic/visual-basic...k-automation-hanging-address-book#post3705302
Last edited:
