• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 67
  • Last Modified:

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.
0
thandel
Asked:
thandel
  • 9
  • 7
1 Solution
 
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 9
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now