Outlook2016 Access2010 docmd.sendobject method crashes

Leo_Polla_Psemata · May 16, 2016

Hi ,
We used to have outlook and access 2010 version.
A huge communication workflow was fully covered by docmd.sendobject method.

Now we upgraded to ofice365, outlook2016 but we left the old Access2010 version .
It appears that Access 2010 can no longer send email using doCmd.SendObject to Outlook 2016
because Access hangs after the email has sent. I mean, the email reaches destination but we have to close and restart db.

Is there any solution to this problem ? ?

GohDiamond · May 17, 2016

Did you attempt to debug? What line is it hanging on? do you have error trapping in the procedure? How about On Error Resume Next?

We need a little more information... let us know more after you attempt to ctrl+<break> and debug.

Cheers!
Goh

Leo_Polla_Psemata · May 18, 2016

Hi
The entire db gets frozen.
There are some emails we send using the docmd.sendobject method.
There are some reports, on these report we have designed a button.
Behind this button, we have assigned the docmd.sendobject method.
Once we click, we get the email ready to send, the docmd prepairs
the "To: , CC: " , the subject, the attachment and the body of the email.

With office 2010, no problem at all.
Now, with office 2016 and the access 2010, once we click the button,
the docmd works, the email is ready, once we click send, the email reaches destination
however the access stucks - freezes (hangs), we have to close it from task manager and restart.

Leo_Polla_Psemata · May 18, 2016

I tried the
On Error Resume Next?
nothing.

In fact I don't get any error message.
After the email is gone, the Access just doesn't respond.
You may wait few minutes before it prompts you to "restart" or force "end task" from the task manager.

And, suppose we click the send email button, we see on the screen the email ready but we don't send. We cancel the email.
Again Access gets frozen as if we had send the email.

Minty · May 18, 2016

Is the attachment a pdf by any chance ?

Leo_Polla_Psemata · May 18, 2016

Yes
Attachment is PDF
however there are other docmd.send object without attachment,
just subject and email body.
The problem is the same
Once we call outlook 2016, the email can go, the db will stop responding.

So, the file attachment doesn't have something to do with it

Minty · May 18, 2016

Are the Office versions that aren't working streamed (Click To Run) install or local versions ?
https://technet.microsoft.com/en-us/library/jj219420.aspx

I know that the Click to Run versions break Automation Object programming.

Leo_Polla_Psemata · May 18, 2016

I am afraid , it is click to run.
I wonder if I buy just one license for one access 2016
and use the free "Microsoft Access 2016 Runtime" edition
for the other users, is this going to work ?

Outlook2016 Access2010 docmd.sendobject method crashes

Leo_Polla_Psemata

Registered User.

GohDiamond

"Access- Imagineer that!"

Leo_Polla_Psemata

Registered User.

Leo_Polla_Psemata

Registered User.

Minty

AWF VIP

Leo_Polla_Psemata

Registered User.

Minty

AWF VIP

Leo_Polla_Psemata

Registered User.

Similar threads

Users who are viewing this thread