I've been stuck on this one for a while now & have probably exhausted all of my help files & related web sites found via google. I have an access db that currently has a button on a form where the user can click & it automatically sends an email to all managers listed in a table. The email has a list of applications for which the employees under him/her has access to. The manager has to reply to the email with a yes/no next to each application in order to determine if access should be revoked.
We currently have it so that when the replies from the managers are received, the users have to manually update the database accordingly as to whether or not revoke access to an application for the given employee. (This is currently a form they update that pulls from a simple field in a table that has yes/no to revoke).
My question & new mission given by my boss, how can I set it up so that the database gets updated automatically with the yes/no responses from the email? Does anybody maybe have any sample VBA code that will allow me to automate the creation, sending & receiving of emails?
I know that '07 offers a new functionality to Create Email, but this wizard is too complex for the users I am working with & this all needs to be done behind the scenes with the main prompt being to choose the managers or department to send it too.
I know I have my work cut out for here b/c I'd imagine this isn't going to be easy.... Any help/advice you could give would be GREATLY appreciated!