Solved

"Microsoft Access Can't Open the Mail Session

Posted on 2007-11-27
9
1,709 Views
Last Modified: 2012-06-27
Hi experts...  I got this problem:  when I try to send an email from Access 97 to Microsoft Outlook 2007, with WinXP Prof as OS. I use "sendobject" method, as I used before, but now I get the message Error Message: "Microsoft Access Can't Open the Mail Session. Check Your Mail Application to Make Sure That It's Working Properly."

I tried this:

RESOLUTION
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To resolve this issue, delete the following registry key. To do so, follow these steps:
1.      Start Registry Editor (Regedit.exe).      
2.      Delete the following registry key:  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Common\MapiDLL       

But... I didnt work  :(      any idea???

Thanks

0
Comment
Question by:modeza
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 10

Expert Comment

by:slamhound
ID: 20362276
can you post your sendmail code please.
0
 
LVL 10

Expert Comment

by:slamhound
ID: 20362307
You can also try using some code like this:

        Set golApp = New Outlook.Application
        Set objNewMail = golApp.CreateItem(olMailItem)
        With objNewMail
       
            .Recipients.Add avarRecip ' To
            .Subject = strSubject
            .Body = strBody
            .HTMLBody = strBody
           
            blnResolveSuccess = .Recipients.ResolveAll
           
            If blnResolveSuccess Then
                .Send ' The email ends up in the Outbox in Outlook

                MsgBox "Congratulations! Your mail has been sent."

            Else
                MsgBox "Unable to resolve all the email addresses. Please check the names."
                .Display
            End If
        End With
0
 

Author Comment

by:modeza
ID: 20368100
Hi...

Im not using code... Im just using controls (command buttom) .. (run application)

Thanks
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 10

Expert Comment

by:slamhound
ID: 20369895
OK, can you post the code behind the button then.
0
 

Author Comment

by:modeza
ID: 20375880
Its not a problem with microsoft access.. because I tried the data base in another computer.. and the control works very well...
The problem its just in that computer...  when I click the bottom to send the email ... It just send the error:
"Microsoft Access Can't Open the Mail Session. Check Your Mail Application to Make Sure That It's Working Properly."


Thanks
0
 

Author Comment

by:modeza
ID: 20396985
Any idea????

thanks
0
 
LVL 10

Accepted Solution

by:
slamhound earned 500 total points
ID: 20400842
I would say that email on the PC that's failing has not been installed properly. Try sending/recieving emails from this machine and resolve and issues that you see.

Make sure that all the latest patches have been installed for Office and Windows.
0
 

Author Comment

by:modeza
ID: 20496033
Im still having the problem

Thanks anyways
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question