email goes to outbox

[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.

[Michael Bauer [MVP - Outlook]]

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>

Post by 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.

[bobh]

Post by Michael Bauer [MVP - Outlook]
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>

Post by 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.- Hide quoted text -

- Show quoted text -

So, the only way Outlook can send a message is to put it in it's
'outbox' first???
and I don't have a clue as to what you are saying, do you have any
vba examples you can share?
bobh

[Michael Bauer [MVP - Outlook]]

Post by bobh
So, the only way Outlook can send a message is to put it in it's
'outbox' first???

No. Outlook just shows the message there as long as it isn't sent. If you
want to send a message by code, it might take up to about one minute. That
means, if you had started the application, and terminate it too early, the
message won't get sent but stays in the outbox.

Post by bobh
and I don't have a clue as to what you are saying, do you have any
vba examples you can share?
bobh

I'm sorry, no.
--
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>

Post by bobh

Post by Michael Bauer [MVP - Outlook]
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>

Post by 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.- Hide quoted text -

- Show quoted text -

So, the only way Outlook can send a message is to put it in it's
'outbox' first???
and I don't have a clue as to what you are saying, do you have any
vba examples you can share?
bobh