MS Access 2003 - Email help

Hi guys

I have created a database in Access for a client of mine which captures all their credit applications. If the application is approved, a request for access codes (username and password) is send to another user using their email program.

This Access file will be installed on 5 computers and when each of them captures an application form, and the e-mail is sent, that users name will appear in the "from" field, which is what I dont want. How can I code in Access that it either uses another account (set in MS Outlook) or hardcode it in Access that it comes from another user?

This is the code that I use and it works perfectly, except for the part explained above.

Private Sub AccessCodes_Click()
DoCmd.SendObject _
acSendReport, _
"emaildisclaimer", _
acFormatTXT, _
[RequestAccessCodeEmail], _
[SalesRepEmail] & ";" & [AdminEmail], _
[SalesAdminEmail], _
[Subject_from_Language], _
[Forms]![frm_clients_addnew]![RequestAccessCode_exp], _
False
End Sub

Is there no one that can help ? Pleeeeeease!

Originally posted by Nicksten
I have created a database in Access