Sending Email ERROR

[nobleadi]

Hi, I have spoken to our external IT team regarding this error and they assumed that the error was possibly caused by my version of O365? They uninstalled 64bit and installed 32bit in the hope that it would resolve the issue. Unfortunately it remains the same.

Outlook is my default mail client.



Can anyone suggest a fix please?

[CJ_London]

there are various ways of sending emails from access, which one are you using? Please provide the code, it could be you have field/variable names which are reserved words which can cause misleading errors.

Also is this code that has worked in the past and stopped working when O365 was installed?

[nobleadi]

there are various ways of sending emails from access, which one are you using? Please provide the code, it could be you have field/variable names which are reserved words which can cause misleading errors.

Also is this code that has worked in the past and stopped working when O365 was installed?

Thanks for your quick response. I'm new to posting anything on forums and wasn't expecting an answer so quickly!

Code:

Private Sub Command262_Click()

DoCmd.SendObject acSendNoObject, , , "example@example.co.uk", , , "Test", True


End Sub


I have tried a somewhat more complicated code but it returned the same result. The error doesn't seem to suggest that there is a code issue but more of a communication issue.

I haven't tried it with any other versions, only 365.

Thanks

[Welshgasman]

What happens when you click an email link on your computer?, does Outlook open a email with that email address?

[nobleadi]

I have just this minute transferred the database over to my own laptop and it works fine. Code is working and the email has sent. I've now narrowed it down to how my works laptop is set up ..... somehow.

[Welshgasman]

Well start with, Do you have a default Email client.?

[nobleadi]

I have. Both settings are 'identical' as far as i see regarding defaults. Tools, reference in VBA is identical also.

[Welshgasman]

I have. Both settings are 'identical' as far as i see regarding defaults. Tools, reference in VBA is identical also.

And it is O365 on both computers?

Try using Outlook with automation? That works with me, quite a neat way for a blank email I must admit.

[nobleadi]

And it is O365 on both computers?

Try using Outlook with automation? That works with me, quite a neat way for a blank email I must admit.

I Have, i think, narrowed down to the version of Windows. The code works on pc's running 10pro 1909 but not on 2004. Million dollar question is what is the difference!!

[Welshgasman]

I Have, i think, narrowed down to the version of Windows. The code works on pc's running 10pro 1909 but not on 2004. Million dollar question is what is the difference!!

Nice one
Only MS can tell you that.

I'd certainly roll them back for now.

https://duckduckgo.com/?t=palemoon&q...roblems&ia=web

[isladogs]

There is another possibility to consider - use Collaborative Data Objects (CDO) to send emails direct from your Access app without involving Outlook at all.
See http://www.mendipdatasystems.co.uk/e...ter/4594365455

[nobleadi]

Just to say that the issue is fixed. Apparently it is something to do with my profile set-up but unfortunately don't know what. Rather than trying to find which registry that was at fault, a new profile was created. All good!

Thank you all for your input.

[Welshgasman]

Just to say that the issue is fixed. Apparently it is something to do with my profile set-up but unfortunately don't know what. Rather than trying to find which registry that was at fault, a new profile was created. All good!

Thank you all for your input.

It happens. I joined one of the big banks as a temp once or twice and one of them cocked up my profile?
Shame as they had plenty to copy from.