Outbox not responding

Status
Not open for further replies.
R

Rose B

I have a MS Access application which uses VB to construct/send emails.

The application is used by some users with Office 2007 and some using Office

2003.

The Office 2007 users have "ClickYes" software from ContextMagic installed.

The MS Access application is distributed as 2007 runtime.

What I have found is that all is well for Office 2007 users all of the time,

and for Office 2003 users if Outlook is closed when the email is sent

(ClickYes accepting the security alert boxes). However, if a Office 2003 user

has Outlook open (which is normal) when the .Send command is issued from VB

then they will see a box stating that the "action cannot be completed becuase

the Outbox - Microsoft Outlook application (Outbox - Microsoft Outlook) is

not responding. Cjoose Switch To to activate Outbox...........". The user can

then click one of two buttons - Switch To... or Retry. Whichever they click

dies the trick and the application continues OK.

Does anyone know of any way of stopping this box from appearing and the

processing continuing without user intervention?

(I will post this in the Access Programming forum as well).
 
For me it sounds like you should ask the ClickYes people.

Best regards

Michael Bauer

Am Tue, 30 Mar 2010 15:42:01 -0700 schrieb Rose B:


> I have a MS Access application which uses VB to construct/send emails.
> The application is used by some users with Office 2007 and some using


Office
> 2003.
> The Office 2007 users have "ClickYes" software from ContextMagic


installed.
> The MS Access application is distributed as 2007 runtime.

> What I have found is that all is well for Office 2007 users all of the


time,
> and for Office 2003 users if Outlook is closed when the email is sent
> (ClickYes accepting the security alert boxes). However, if a Office 2003


user
> has Outlook open (which is normal) when the .Send command is issued from


VB
> then they will see a box stating that the "action cannot be completed


becuase
> the Outbox - Microsoft Outlook application (Outbox - Microsoft Outlook) is
> not responding. Cjoose Switch To to activate Outbox...........". The user


can
> then click one of two buttons - Switch To... or Retry. Whichever they


click
> dies the trick and the application continues OK.

> Does anyone know of any way of stopping this box from appearing and the
> processing continuing without user intervention?

> (I will post this in the Access Programming forum as well).
 
Yeah, I did that - and they said that their product could not code around

this message. The strange thing is that if you use Mail Merge to generate

Outlook messages from Access, this message does not appear (and of course the

security messages are handled OK by ClickYes), so I thought that there must

be some kind of flag that is being set by Mail Merge and that I am missing in

my VB statement.

"Michael Bauer " wrote:



> For me it sounds like you should ask the ClickYes people.

> > Best regards
> Michael Bauer
> Category Manager -

> SAM - The Sending Account Manager:
>

> Am Tue, 30 Mar 2010 15:42:01 -0700 schrieb Rose B:
>
> > I have a MS Access application which uses VB to construct/send emails.
> > The application is used by some users with Office 2007 and some using

> Office
> > 2003.
> > The Office 2007 users have "ClickYes" software from ContextMagic

> installed.
> > The MS Access application is distributed as 2007 runtime.
> > What I have found is that all is well for Office 2007 users all of the

> time,
> > and for Office 2003 users if Outlook is closed when the email is sent
> > (ClickYes accepting the security alert boxes). However, if a Office 2003

> user
> > has Outlook open (which is normal) when the .Send command is issued from

> VB
> > then they will see a box stating that the "action cannot be completed

> becuase
> > the Outbox - Microsoft Outlook application (Outbox - Microsoft Outlook) is
> > not responding. Choose Switch To to activate Outbox...........". The user

> can
> > then click one of two buttons - Switch To... or Retry. Whichever they

> click
> > dies the trick and the application continues OK.
> > Does anyone know of any way of stopping this box from appearing and the
> > processing continuing without user intervention?
> > (I will post this in the Access Programming forum as well).

> .
>
 
It's not a flag. It's a message created using Simple MAPI that is causing

the problems. You're probably using DoCmd to send the mail? You would need

to start Outlook using automation code and use the Outlook object model to

avoid the problem and to have ClickYes work correctly.

"Rose B" <RoseB> wrote in message

news:C561F798-4CC4-474C-A941-8697DF3C91F0@microsoft.com...
> Yeah, I did that - and they said that their product could not code around
> this message. The strange thing is that if you use Mail Merge to generate
> Outlook messages from Access, this message does not appear (and of course
> the
> security messages are handled OK by ClickYes), so I thought that there
> must
> be some kind of flag that is being set by Mail Merge and that I am missing
> in
> my VB statement.
 
The code that I am using follows..... which I think is the kind of thing that

you are suggesting?

Dim appOutlook As Object

Dim appOutlookMsg As Object

Dim appOutlookRecip As Object

Set appOutlook = CreateObject("Outlook.Application")

Set appOutlookMsg = appOutlook.CreateItem(olMailItem)

strRecipient = "rose.b@tiscali.co.uk"

With appOutlookMsg

Set appOutlookRecip = .Recipients.Add(strRecipient)

appOutlookRecip.Type = olTo

> Importance = 2

> Subject = "Test Msg"

> Body = "Dear You, this is a test message from Access 2007"

> Send

End With
wrote:


> It's not a flag. It's a message created using Simple MAPI that is causing
> the problems. You're probably using DoCmd to send the mail? You would need
> to start Outlook using automation code and use the Outlook object model to
> avoid the problem and to have ClickYes work correctly.

> >

>

> "Rose B" <RoseB> wrote in message
> news:C561F798-4CC4-474C-A941-8697DF3C91F0@microsoft.com...
> > Yeah, I did that - and they said that their product could not code around
> > this message. The strange thing is that if you use Mail Merge to generate
> > Outlook messages from Access, this message does not appear (and of course
> > the
> > security messages are handled OK by ClickYes), so I thought that there
> > must
> > be some kind of flag that is being set by Mail Merge and that I am missing
> > in
> > my VB statement.


> .
>
 
That is Outlook automation, not Simple MAPI, so it is what I was talking

about. I'm really surprised that ClickYes can't handle that.

You might want to try using GetObject() to see if you can pick up an

existing Outlook session before you use CreateObject(), perhaps ClickYes can

handle that.

I don't use ClickYes, nor do most Outlook developers. I consider it a

security risk, and we have Redemption (www.dimastr.com/redemption) to avoid

the security and provide a whole heck of a lot more functionality than

ClickYes.

"Rose B" <RoseB> wrote in message

news:4B0F4050-7D4D-4F1A-8E81-4E64250EC452@microsoft.com...
> The code that I am using follows..... which I think is the kind of thing
> that
> you are suggesting?

> Dim appOutlook As Object
> Dim appOutlookMsg As Object
> Dim appOutlookRecip As Object

> Set appOutlook = CreateObject("Outlook.Application")
> Set appOutlookMsg = appOutlook.CreateItem(olMailItem)
> strRecipient = "rose.b@tiscali.co.uk"

> With appOutlookMsg
> Set appOutlookRecip = .Recipients.Add(strRecipient)
> appOutlookRecip.Type = olTo
> .Importance = 2
> .Subject = "Test Msg"
> .Body = "Dear You, this is a test message from Access 2007"
> .Send
> End With
 
Thanks Ken.... I solved it!!! (And a real Doh! moment it was too). Somehow

the OLE Automation library had been dropped. Once I put that into the

References all was OK.

I had looked at Redemption before, but the folk I have been doing this for a

re a charity and there are only a couple of users so they didn't really want

to be buying software. I have also looked today at MAPILab's Advanced Outlook

Security, which looks much more rich in functionality. At least with ClickYes

whether it is Active or not can be controlled through VB so it won't just

click through all the time.

Anyway, all's well - thanks for your time.
wrote:


> That is Outlook automation, not Simple MAPI, so it is what I was talking
> about. I'm really surprised that ClickYes can't handle that.

> You might want to try using GetObject() to see if you can pick up an
> existing Outlook session before you use CreateObject(), perhaps ClickYes can
> handle that.

> I don't use ClickYes, nor do most Outlook developers. I consider it a
> security risk, and we have Redemption (www.dimastr.com/redemption) to avoid
> the security and provide a whole heck of a lot more functionality than
> ClickYes.

> >

>

> "Rose B" <RoseB> wrote in message
> news:4B0F4050-7D4D-4F1A-8E81-4E64250EC452@microsoft.com...
> > The code that I am using follows..... which I think is the kind of thing
> > that
> > you are suggesting?
> > Dim appOutlook As Object
> > Dim appOutlookMsg As Object
> > Dim appOutlookRecip As Object
> > Set appOutlook = CreateObject("Outlook.Application")
> > Set appOutlookMsg = appOutlook.CreateItem(olMailItem)
> > strRecipient = "rose.b@tiscali.co.uk"
> > With appOutlookMsg
> > Set appOutlookRecip = .Recipients.Add(strRecipient)
> > appOutlookRecip.Type = olTo
> > .Importance = 2
> > .Subject = "Test Msg"
> > .Body = "Dear You, this is a test message from Access 2007"
> > .Send
> > End With


> .
>
 
If you do more Outlook projects, Redemption for sure will pay off. There'd

be no need to have one customer pay for the entire cost.

Best regards

Michael Bauer

Am Wed, 31 Mar 2010 09:44:01 -0700 schrieb Rose B:


> Thanks Ken.... I solved it!!! (And a real Doh! moment it was too). Somehow
> the OLE Automation library had been dropped. Once I put that into the
> References all was OK.

> I had looked at Redemption before, but the folk I have been doing this for


a
> re a charity and there are only a couple of users so they didn't really


want
> to be buying software. I have also looked today at MAPILab's Advanced


Outlook
> Security, which looks much more rich in functionality. At least with


ClickYes
> whether it is Active or not can be controlled through VB so it won't just
> click through all the time.

> Anyway, all's well - thanks for your time.

> " - " wrote:
>
> > That is Outlook automation, not Simple MAPI, so it is what I was talking
> > about. I'm really surprised that ClickYes can't handle that.
>

>> You might want to try using GetObject() to see if you can pick up an
> > existing Outlook session before you use CreateObject(), perhaps ClickYes


can
> > handle that.
>

>> I don't use ClickYes, nor do most Outlook developers. I consider it a
> > security risk, and we have Redemption (www.dimastr.com/redemption) to


avoid
> > the security and provide a whole heck of a lot more functionality than
> > ClickYes.
>

>> > >

> >

>

>
>
>
>
>
>> "Rose B" <RoseB> wrote in message
> > news:4B0F4050-7D4D-4F1A-8E81-4E64250EC452@microsoft.com...
> >> The code that I am using follows..... which I think is the kind of thing
> >> that
> >> you are suggesting?
> >
>>> Dim appOutlook As Object
> >> Dim appOutlookMsg As Object
> >> Dim appOutlookRecip As Object
> >
>>> Set appOutlook = CreateObject("Outlook.Application")
> >> Set appOutlookMsg = appOutlook.CreateItem(olMailItem)
> >> strRecipient = "rose.b@tiscali.co.uk"
> >
>>> With appOutlookMsg
> >> Set appOutlookRecip = .Recipients.Add(strRecipient)
> >> appOutlookRecip.Type = olTo
> >> .Importance = 2
> >> .Subject = "Test Msg"
> >> .Body = "Dear You, this is a test message from Access


2007"
> >> .Send
> >> End With

>

>> .
> >
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Horsepower Cannot delete gmail in iPhone Outlook outbox Using Outlook 1
C How to search for items in Outbox with multiple accounts? Using Outlook 20
J E-mail held in Outbox while Minimized Using Outlook 3
L Need help modifying a VBA script for emails stuck in Outbox Outlook VBA and Custom Forms 6
B Emails get stuck in Outbox of Gmail IMAP in Outlook for Windows Using Outlook 0
GregS Outlook 2016 Can I disable the Outlook Outbox? Using Outlook 2
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
B One email cannot be sent or received (but leaves outbox!) Using Outlook 1
U Outbox Message Stuck after reading some MailItem Properties with VBA Outlook VBA and Custom Forms 1
A Cant See outbox items on a secondary Account Exchange Server Administration 3
M Outbox throttler Using Outlook 4
T SMTP messages stuck in Outbox Using Outlook 0
I Outlook 2013 Send mail - it just sticks in Outbox Using Outlook.com accounts in Outlook 0
P Outlook 2013 puts replies in Outbox Using Outlook 1
Diane Poremsky After viewing the Outbox, messages won't send Using Outlook 0
D Close Oulook after sending emails via vba without outbox getting stuck. Outlook VBA and Custom Forms 1
M Messages in Outbox reminder is wrong Using Outlook 4
D Use single outbox in Outlook 2013 Using Outlook 1
T Two Outbox's in 2007 but neither send Using Outlook 8
iwshim Transfering mail from the outbox to another computer Using Outlook 0
G "Delay Delivery" Email fails to send if opened while in Outbox Using Outlook 4
F Outbox - Multiple Emails need to be manually opened? Using Outlook 5
B OUTBOX ERROR!!!!! Using Outlook 20
James Emails Stuck In Outlook Outbox Happening Alot Using Outlook 1
Loperman Emails hang in Outbox Using Outlook 1
C Outlook 2013 - Email Gets Sent - But Does Not Move From Outbox to Sent Box Using Outlook 4
M some emails send from outbox, some don't Using Outlook 10
S Mystery emails in Outbox Using Outlook 1
J Change Subject of 500 mails sitting in Outbox with Macro Using Outlook 6
B Cannot send emails-stuck in OutBox: OUTLOOK 2013 Using Outlook 4
E lost contacts on emptying outbox? Using Outlook 5
N Stuck in Outlook 10 Outbox Using Outlook 0
M Messages Held in Outbox 2007 Outlook 2010 Using Outlook 1
K blank emails generated in outbox when clicking on Inbox and other foders Using Outlook 0
R Force use of general outbox Using Outlook 1
J Emails stuck in Outlook outbox Using Outlook 11
P OL 2007 XP email stuck in outbox Using Outlook 3
D Email stuck in Outbox Using Outlook 3
X Exchange 2013 - Emails stuck in Outbox folder Exchange Server Administration 3
D Emails stuck in Outbox, not receiving emails, Outlook 2010 auto send/receive Using Outlook 4
D Outbox will not send, error code 0X800CCC78 with 550 sender restricted. Using Outlook 3
G Email stuck in Outbox - Office 2013 Using Outlook 5
N Email Stuck in Outbox - Cached Mode - Roaming Profile Using Outlook 2
D Windows 7 / Outlook 2007 - email gets stuck in Outbox Using Outlook 2
A Mail Merge - Sent but still in Outbox Using Outlook 5
T Sent emails remain in Outbox Using Outlook 3
P Messages stuck in outbox and must be sent again. Using Outlook 1
C Fix for Outlook Outbox Error Message Using Outlook 1
J Outlook 2010 messages freeze in outbox, do not autosave, then disappear after Outlook locks up Using Outlook 7

Similar threads

Back
Top