Solved

"Microsoft Access Can't Open the Mail Session

Posted on 2007-11-27
9
1,694 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

770 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