Solved

"Microsoft Access Can't Open the Mail Session

Posted on 2007-11-27
9
1,686 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
  • 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
 
LVL 10

Expert Comment

by:slamhound
ID: 20369895
OK, can you post the code behind the button then.
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now