We help IT Professionals succeed at work.
Get Started

Update Access Database Automatically using Email Message

Daisy80
Daisy80 asked
on
797 Views
Last Modified: 2013-11-28
Hi all-

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!

Thanks!
Comment
Watch Question
IT Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 21 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE