• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

Microsoft Access 97 can't send a message in Windows Mail

I am using Access 97 and running a macro using sendobject. This macro has worked with access 97, outlook express, and windows xp.

I have now tried this macro on a vista machine using windows mail. But I get an error: Microsoft  access can't send a message for the reason stated in the preceeding Alert. Resolve the problem and then send again. I do not see any preceeding alert.

Any help appreciated

  • 3
  • 2
  • 2
1 Solution
Jeffrey CoachmanMIS LiasonCommented:

See this link:
and this perhaps:

Please be aware that there is a 12 year difference in technology between the two products you are using.

Although Access 97 will run on vista, Microsoft may not guarantee that all the functionality will work.

Many Files are shared between MSOffice and MSWindows.
The files that Access 97 might need, may not be available in Vista.

Then only thing you can do is make sure that Access 97 is up to date with all Service Packs.

Let's see if another Expert might have more insight...

You are describing the infamous Access 2002+ and Vista security pain in the butt problem. What MS says about why they have decided to make our life miserable and how to deal with it:

Vista's increased security makes life even more fun by suppressing the "preceeding alert" so that we all can be totally confused.

Two ways to handle it for files used internally:
The safer way: Use SelfCert.exe http://support.microsoft.com/kb/q217221/
The easier way: Tools > macros > security level low (won't work with Vista)

The only way to handle it if you are publishing your software is to buy an certificate. The least expensive certificate I have found is $99/year, $179/2 years at:

Frequently asked questions about Access security warnings:

How to certify can be found at:

Other places to buy a certificate:
BTW: Hi Jeff!
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Jeffrey CoachmanMIS LiasonCommented:

Nice of you to drop by and Bail me out.

Just to be sure, this is the Access 97 version of the message:
 "Outlook is trying to send email on your behalf..." message?

If s,o would CDO or Outlook Redemption be an option?

TomcptAuthor Commented:
Jeff that is my guess too. The files are not availabale for vista and mail. I will keep looking for a solution on the web. Thanks
Jeffrey CoachmanMIS LiasonCommented:
keep us posted
TomcptAuthor Commented:
The setup cannot be done with Vista Microsoft Mail. Thanks for everyone's help.
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now