Steven_Flint
asked on
Access MAPI email using Remote Desktop Connection
Scenario
MS Access version 2002 front end and back end database on Win2000 server.
Client access to database via Remote Desktop Connection from various platforms, mainly Win2000.
There is an option to email reports and I have set up a MAPI function to achieve this, thanks in no small way to the very helpful answer given to another question by TextReport, see Q_20338946.html for answer.
This works well except that wherever the MAPI function is called from, i.e. a user in Queensland or in Victoria the default profile on the server is placed in the e-mail From property, therefore whoever sends the e-mail it appears to come from one user.
I could set up the default profile on the server to something like DB Report, but that's little agricultural.
So the question is can I set the From property of the e-mail to the client user name in the MAPI code that I am using, prior to sending it?
Regards
Steven.
MS Access version 2002 front end and back end database on Win2000 server.
Client access to database via Remote Desktop Connection from various platforms, mainly Win2000.
There is an option to email reports and I have set up a MAPI function to achieve this, thanks in no small way to the very helpful answer given to another question by TextReport, see Q_20338946.html for answer.
This works well except that wherever the MAPI function is called from, i.e. a user in Queensland or in Victoria the default profile on the server is placed in the e-mail From property, therefore whoever sends the e-mail it appears to come from one user.
I could set up the default profile on the server to something like DB Report, but that's little agricultural.
So the question is can I set the From property of the e-mail to the client user name in the MAPI code that I am using, prior to sending it?
Regards
Steven.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I will leave the following recommendation for this question in the Cleanup topic area:
Split: jadedata {http:#9606260} & TextReport {http:#9609333}
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
stevbe
EE Cleanup Volunteer