Error# 2287 - Microsoft Access can not open the mail session

[irish634]

Hi all,

I've searched the net and forum and found no real solution. I have a client who is getting this error when trying to send a report.

Not that it matters but my exact code is:

DoCmd.SendObject acReport, "rpt_JobReport", sFormatName, "", "", "", "", "", True, ""

My client is in Australia so I don't have the particulars until he wakes up (Email client, OS, etc). The database is in 2003 format. I am going under the assumption he has an email client installed such as Outlook or Outlook Express, but I have never run into this when any email client is installed on a pc.

I've tested this on 4 different PCs in both Access 2000 and 2003 and I can not reproduce the error.

I've found solutions from deleting a registry key, to re-installing office, but nothing really definitive.

Could a reference be missing?
I have the following:

1. Visual Basic for Applications
2. Microsoft Access 9.0 Object Library (The 9.0 is dependent on what pc I'm on with a different version of access).
3. Microsoft DAO 3.6 Object Library
4. Microsoft ActiveX Data Objects 2.8
5. OLE Automation

Has anyone ever run into this and how was it corrected?
Craig

 

[irish634]

Well, here's a little update:

The code works fine in these scenarios:
WinXP - Access 2000 - Outlook 2000
WinXP - Access 2003 w/Runtime - Outlook 2000
WinXP - Access 2000 - Netscape Email
WinXP - Access 2000 - Outlook 2003
WinXP - Access 2003 - Outlook 2003
WinXP - Access 2003 - Mozilla Thunderbird

WinXP - Access 2000 - No Email Client - All this does is try to setup an email account. But does not generate the error