"Microsoft Access Can't Open the Mail Session

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

modezaAsked:
Who is Participating?
 
slamhoundCommented:
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
 
slamhoundCommented:
can you post your sendmail code please.
0
 
slamhoundCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
modezaAuthor Commented:
Hi...

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

Thanks
0
 
slamhoundCommented:
OK, can you post the code behind the button then.
0
 
modezaAuthor Commented:
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
 
modezaAuthor Commented:
Any idea????

thanks
0
 
modezaAuthor Commented:
Im still having the problem

Thanks anyways
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.

All Courses

From novice to tech pro — start learning today.