Help Please!

[Nick]

We have an Access database which users access via Terminal Server. On some
of our data entry forms, the users have the option of pressing a command
button and e-mailing a report automatically. Basically, a new e-mail box
automatically opens, with the report attached, already addressed to a list
of recipients. All they have to do is add comments to the body of the
e-mail if they choose and the push the send button.

This functionality works just fine on my local database, where I make/test
code changes. However, when accessed through Terminal Server, users get a
prompt to choose MS Exchance as their profile settings, and only then will
the e-mail box deploy. Once they exit the database, they have to do this
all over again each time they try to use the command button to e-mail a
report.

How do I stop the prompt from appearing? It is annoying me and the rest of
our users. Any help here would be greatly appreciated. Please let me know
if my explanation has not been adequate.

Thanks in advance,

Nick C.

 

[Dave Corun]

How are you spawning the New E-mail dialog now?

Consider using CDO to do your e-mailing. You can hide the "Ms Exchange"
login dialog and the profile settings that way. You can also have it place
a copy of the message in the Sent Items of the senders box if you wanted.

Hope that helps!

// Dave


We have an Access database which users access via Terminal Server. On some
of our data entry forms, the users have the option of pressing a command
button and e-mailing a report automatically. Basically, a new e-mail box
automatically opens, with the report attached, already addressed to a list
of recipients. All they have to do is add comments to the body of the
e-mail if they choose and the push the send button.

This functionality works just fine on my local database, where I make/test
code changes. However, when accessed through Terminal Server, users get a
prompt to choose MS Exchance as their profile settings, and only then will
the e-mail box deploy. Once they exit the database, they have to do this
all over again each time they try to use the command button to e-mail a
report.

How do I stop the prompt from appearing? It is annoying me and the rest of
our users. Any help here would be greatly appreciated. Please let me know
if my explanation has not been adequate.

Thanks in advance,

Nick C.