question

GregTab-8865 avatar image
0 Votes"
GregTab-8865 asked thedbguy answered

DoCmd.SendObject Fails after converting to .accde Access 365 32-bit

I have a simple button on an Access 365 accdb
the button grabs the email address from the form and opens my email program
It works fine on both 32 bit and 64 bit.

when convert the accdb to accde it fails.
on the 32 bit it simply quits the program after about 10 seconds.
in the 64 bit it produces an error 2046 "The command or action SendObject isn't available..."

I have also verified that the location of the files are in a trusted location. I have even added C:\ and all subs as a trusted location.

Code below attached to onClick Button

Dim txt_To As String
On Error GoTo Error_Handler
txt_To = Me.Email
DoCmd.SendObject , , , txt_To, txt_CC, txt_BCC, txt_Subject, txt_Msg
MsgBox "Sucess Your Email has been was Sent to " & txt_To
Error_Handler_Exit:
On Error Resume Next
Exit Sub
Error_Handler:
MsgBox Err.Number & vbCrLf & Err.Description
Resume Error_Handler_Exit


Any suggestions would be helpfull.

Thank you

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

thedbguy avatar image
0 Votes"
thedbguy answered

At the top of your module, add the following line:

Option Explicit

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.