DoCmd.SendObject Fails

Hi Experts!

To send an email within MS Access 2003 I've been using the following command code for years... with Outlook 2010 without any issues:

DoCmd.SendObject , , , Me.Email, , , sSubject, sBody, iEmailView

Lately on one computer the command fails with a run time error of 2293.  If I close and restart Outlook it will work for a short period of time and then the same issue occurs.

Looking for a solution to prevent this failure from occurring.  Thank you.  

Thank you.
thandelAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
This is likely due to an Outlook update. See this Microsoft article:

https://support.microsoft.com/en-us/help/263084/how-to-work-with-the-outlook-e-mail-security-update-in-an-access-datab

Since it seems to be at random, you might also repair/reinstall Office.
0
thandelAuthor Commented:
I will try the repair feature abut also look into the security update... I can't tell what is the KB number that provided the security update... can you tell?   Also I'm not getting the "do you want to send..." prompting.  The command fails before that so I'm not sure its related to the security update.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You won't necessarily get a prompt.

The Docmd line you're showing should work, assuming your variables are correct.
0
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

thandelAuthor Commented:
Ok thanks do you know what the KB update was that caused the issue?  I was not able to determine it from the link you had provided.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm not sure there was a specific update
0
thandelAuthor Commented:
OK thanks, so if I follow correctly you suggestion is to run a repair and that was all I should try at this point, correct?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Well, that's the first step. As I mentioned, your code should run (there's no errors that I can see), so the first thought would be environment troubles.
0
thandelAuthor Commented:
OK the repair didn't help... any other suggestions?
0
thandelAuthor Commented:
Have the experts been stumped?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If it's a problem on a single machine, then the trouble is with that machine. If a repair of Office didn't help then the next steps are:

1. Repair the Windows installation
2. Uninstall and reinstall Office
3. Reinstall Windows

It's also possible that you've got a corrupt user profile. To test that, create a new user profile on that machine and see if the trouble persists. If it does, then you're back to one of the 3 items above. If it does not, then you'd need to rebuild that corrupt user profile.
0
thandelAuthor Commented:
Doesn't make sense to have to resinstall windows or office... its an interment issue... when I first start up its working then at some point it fails.  If I close and restart Outlook it will work for a short period of time and then the same issue occurs.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Doesn't make sense to have to resinstall windows or office
Then don't do it. Good luck.
0
thandelAuthor Commented:
I reset the default email client and ever since there hasn't been an issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
How did you "reset the default email client"? I'm curious to know ...
0
thandelAuthor Commented:
I am surprised that this wasn't suggested and things like reinstalling Windows was suggested.  A installation of the OS is there very last resort and of course has huge issues with time as a result.
0
thandelAuthor Commented:
Hi Scott, the default email client was set to Outlook I set it to another email client and then back to Outlook.  Perhaps it rewrote some config  / registry entries as a result.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.