Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

"Microsoft Access Can't Open the Mail Session

Posted on 2007-11-27
9
Medium Priority
?
1,727 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

971 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