troubleshooting Question

Update Access Database Automatically using Email Message

Avatar of Daisy80
Daisy80 asked on
Microsoft Access
21 Comments1 Solution798 ViewsLast Modified:
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!

IT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 21 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros