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?