VBA Code to email (outlook) - Fine in 2016(32bit) / Broken in 365(64bit)

[Gasman]

Have you tried
.Display
.Send ?

 

[Dave1975]

Did SendObject work?

Sent from phone...

send object worked with the 5sec countdown

 

[Dave1975]

Have you tried
.Display
.Send ?

doesnt move to the .send command until the .display is dealt with - then errors. guessed it would but happy to try just about anything.

 

[Gasman]

doesnt move to the .send command until the .display is dealt with - then errors. guessed it would but happy to try just about anything.

Yes, I have only ever used one or the other in the past.
There used to be a warning that a program was trying to send an email from Outlook, and I cannot remember what I had to do to get past it now?
Just wondering if that sort of setting has been applied in someway with the upgrades, so athough you can send from Outlook manually, it is preventing the automated option?

 

[Dave1975]

Yes, I have only ever used one or the other in the past.
There used to be a warning that a program was trying to send an email from Outlook, and I cannot remember what I had to do to get past it now?
Just wondering if that sort of setting has been applied in someway with the upgrades, so athough you can send from Outlook manually, it is preventing the automated option?

because we are using 365 i am now trying to circumvent their security settings aorund outlook by using CDO. not hopeful at present.
looks more and more like its my IT security not enabled automation in outlook in windows 10 even though they allowed it in windows 7

 

[theDBguy]

because we are using 365 i am now trying to circumvent their security settings aorund outlook by using CDO. not hopeful at present.
looks more and more like its my IT security not enabled automation in outlook in windows 10 even though they allowed it in windows 7

Good luck and let us know how that goes.

 

[Dave1975]

Looking 99% percent positive its our security systems. My simple question started an avalanche of complaints against IT (whoops) - need to find the time to see if i can a. circumvent outook or b. convince IT to reverse their crazy decision.

 

[Dave1975]

thank you all for your help though - should this ever get resovled i have a multitude of code options for this.

 

[Gasman]

Looking 99% percent positive its our security systems. My simple question started an avalanche of complaints against IT (whoops) - need to find the time to see if i can a. circumvent outook or b. convince IT to reverse their crazy decision.

I remember one place I worked, the IT people stopped us using some option, that only took one click or two? Nothing bad about this option really, and we needed to use it. but nope, has to stop.
We could still effectively carry out this option, it just took us about ten clicks to do it, by a longer method.

 

[RogerCooper]

Have you tried using Access's direct e-mail capability using DoCmd.SendObject? This requires a manual confirmation which can be dealt with by using ClickYes Pro or an Auto Hot Key script.