?
Solved

Access 2013 E-mail Notitification

Posted on 2015-02-12
3
Medium Priority
?
82 Views
Last Modified: 2015-02-18
I have a database of users and when access will expire, is there a way to set up Access 2013 to send me an e-mail when someone's access will expire ,, ?  - About 10 days before it does ..
?

Columns I made are : Last Name , First Name , ... ... , E-mail address , ... ... ... , Expiration Date
-


?
?

Thanks
0
Comment
Question by:mvalencia2003
  • 2
3 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40607278
Code like this should do what you need:

Private Sub Command0_Click()
'You may wish to purchase a product like this:
'http://www.contextmagic.com/express-clickyes/
'...to avoid the emal warming
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("qry10DayExp")
rst.MoveFirst
Do Until rst.EOF
    DoCmd.SendObject acSendNoObject, , , rst!emailAddress, , , "Expiration", "You will expire in " & rst!DaysTilEXP & " Days, on " & rst!ExpirationDate, False
    rst.MoveNext
Loop

MsgBox "Done"
rst.Close
dbs.Close
Set rst = Nothing
Set dbs = Nothing

End Sub


sample attached as well
Database67.mdb
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 40607280
sorry, here is the code again:
Private Sub Command0_Click()
'You may wish to purchase a product like this:
'http://www.contextmagic.com/express-clickyes/
'...to avoid the emal warming
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("qry10DayExp")
rst.MoveFirst
Do Until rst.EOF
    DoCmd.SendObject acSendNoObject, , , rst!emailAddress, , , "Expiration", "You will expire in " & rst!DaysTilEXP & " Days, on " & rst!ExpirationDate, False
    rst.MoveNext
Loop

MsgBox "Done"
rst.Close
dbs.Close
Set rst = Nothing
Set dbs = Nothing

End Sub

Open in new window

0
 
LVL 31

Expert Comment

by:hnasr
ID: 40610408
You may approach like this:

1 Set a timer event to run a daily procedure to find qualified records, and save to/update a table.
2 Another timer event to run a  function to read the table and send qualified emails.
3 Flag the table to show that a notification was issued.
4 Tou may improve the process to schedule how and when to resend notifications.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question