Cannot open Mail Session

[Ngan Bui]

I have Office XP with Windows 2k.

In my Access XP, I have a sendobject command to create an
email message. below is the function:

DoCmd.SendObject , , , "*Location",, , , "Address is " &
Me!Address & "."

With one user, everytime he clicks on the button, there is
an error that says "Access cannot open mail session".

I log in as someone else on the computer and run the same
thing and it works. I log that one user onto another
machine and it doesn't work. Seems as if it happens only
when the user is logged in and using his outlook.

In the past, I've already recreated his email account and
it fixed the problem. Now it's back.

The one work around I have is if he previews an Access
report, go to File | Export...in the Save In,
choose "desktop"...in the Save File Type, choose "excel 97-
2002"...and then Cancel the export.

When he does that, the sendobject function works as long
as he doesn't close out of the database.

Has anyone found this to be a problem? I can export as an
attachment with the other Office programs, just not Access.

This only happens if the user logs in as himself AND uses
his outlook...it can be on any computer.

 

[Ken Slovak - [MVP - Outlook]]

I've never seen that problem but it certainly sounds like a
permissions problem, either for the database or for Outlook. Have you
compared that user's permissions to others where things work? Have you
posted to an Access group to see if anyone there is familiar with a
similar problem?

Also, is that user's version of Outlook and OS the same as the other
users?

 

[Ngan Bui]

The user is part of the Road Supervisor group and the
other road sups don't have a problem. I haven't changed
their permission in forever. The user has the same type
of machine and programs as the other road sups. Even tho
they have Win98 vs w2k like the rest of the people, the
user even gets this problem when logged into a w2k machine.

I've posted this error the first time it happened to an
access group and didn't really get a fix. The fix was to
recreate his entire user account and email account. I
really don't want to do that again tho.

currently, he is doing the workaround (file | export...).

This is the weird part where the problem is only happening
with access....with the sendobject AND send to | mail
recepient via the preview report. I can send to | mail
recepient in the other office programs just fine.