You need to ensure that Outlook is running until the message is sent: Keep
the reference on Outlook alive, and add an Explorer object. If Outlook is
configured to send messages automatically, it should do so within about one
minute, but you don't know how long sending will take. So, check the outbox
at intervalls and if it's empty, remove the Explorer, and set the ref =
Nothing.

Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 12 Nov 2009 08:32:11 -0800 (PST) schrieb bobh:

> Hi,
>
> My company is switching from Groupwise to Outlook 2007 as it's email
> client, I have a test pc which I'm trying to re-write my AccessXP vba
> code to use Outlook
>
> one process I use is Docmd.SendObject and in the current environment
> that email is sent immediately in the background and Groupwise does
> not need to be open.
> On the test pc with Outlook closed that process causes an Outlook
> Security message and than when I click OK on that the email goes to
> Outbox's outbox and just sits there until I open Outlook
>
> How do I get Outlook to SEND the email after I click OK on the
> security pop-up?
> thanks
> bobh.
12 Nov 2009email goes to outbox.bobh
12 Nov 2009\ Re: email goes to outbox.Michael Bauer [MVP - ...
12 Nov 2009   \ Re: email goes to outbox.bobh
13 Nov 2009      \ Re: email goes to outbox.Michael Bauer [MVP - ...
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)