MS Access can't open the mail session

  • Thread starter Thread starter Jeff Byrd
  • Start date Start date
J

Jeff Byrd

I have programed a snpshot report to be sent by e-amil automatically if a
certain value is chosen in a combo box. This works fine on our local
computers. But we get the message

"Microsoft Access can't open the mail session"

when we run MSAccess in a terminal services session. I have also logged on
to the server and get the same message. I have tried to compare all of the
options in MS Access and MS Outlook 2003 and they appear to be the same.

We are running Office 2003 on both the local computers and on the server.

Any Idea's.
 
Jeff

Do (can) your users use Outlook in Terminal Services? I suspect that they
do not have their mail profiles set up properly. If this is the case you
will have to either:

Set Mail profiles for all of your Terminal services users so they can
use outlook.
or
Use some other way to send the mail. I have had good success sending
mail with CDO.

Ron W
 
Yes they can use Outlook. I just found out that we can not send e-mail from
an office application because we have Exchange Server insatlled on the same
computer as Terminal Services. For some reason it will not let it use mapi.

I am unfamiliar with CDO for mailing. What is it?

Thanks

Jeff


Ron Weiner said:
Jeff

Do (can) your users use Outlook in Terminal Services? I suspect that they
do not have their mail profiles set up properly. If this is the case you
will have to either:

Set Mail profiles for all of your Terminal services users so they can
use outlook.
or
Use some other way to send the mail. I have had good success sending
mail with CDO.

Ron W
Click to expand...
 
I explored CDO a little and found that it is a scripting inteface for MAPI.
This probably willnot work beacuase of Exchange and Terminal services being
on the same machine.

Jeff

Ron Weiner said:
Jeff

Do (can) your users use Outlook in Terminal Services? I suspect that they
do not have their mail profiles set up properly. If this is the case you
will have to either:

Set Mail profiles for all of your Terminal services users so they can
use outlook.
or
Use some other way to send the mail. I have had good success sending
mail with CDO.

Ron W
Click to expand...
 
If you have access to another Email Server - (POP3 is fine) you may still be
able to get where you want to go. If I were you I'd give it a try. I am
sending mail via CDO in everything from Access, ASP, and VB applications.


Ron W
Jeff Byrd said:
I explored CDO a little and found that it is a scripting inteface for MAPI.
This probably willnot work beacuase of Exchange and Terminal services being
on the same machine.

Jeff
Click to expand...
 
Back
Top