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 (MS Outlook).
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 in the email, 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 the email is comming from "admin user"?
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 (MS Outlook).
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 in the email, 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 the email is comming from "admin user"?
