hardhitter06
Registered User.
- Local time
- Today, 09:11
- Joined
- Dec 21, 2006
- Messages
- 600
Hi All,
Using Access and Outlook 2010.
Not sure if this should have been posted in 'Queries' or 'Modules/VBA' so I apologize if it's in the wrong spot.
I have a database that tracks Contracts for our University. One of the fields it tracks is Expiration Date.
Is there a way to have Access prompt Outlook to send an email to my boss when the contract is a month or within a month from expiring?
I'm assuming when the database is opened it would have to run a query for expiration dates expiring within one month of today's date (which i know how to do).
I just don't know if it's possible to generate an email or some kind of message with those records/contract numbers displayed ?
I should also note my boss is the only one who uses this database so even if the email notice isn't possible, is there a way to show a message of what contracts are expiring soon when he opens the DB?
Thank you.
Using Access and Outlook 2010.
Not sure if this should have been posted in 'Queries' or 'Modules/VBA' so I apologize if it's in the wrong spot.
I have a database that tracks Contracts for our University. One of the fields it tracks is Expiration Date.
Is there a way to have Access prompt Outlook to send an email to my boss when the contract is a month or within a month from expiring?
I'm assuming when the database is opened it would have to run a query for expiration dates expiring within one month of today's date (which i know how to do).
I just don't know if it's possible to generate an email or some kind of message with those records/contract numbers displayed ?
I should also note my boss is the only one who uses this database so even if the email notice isn't possible, is there a way to show a message of what contracts are expiring soon when he opens the DB?
Thank you.