I found out only last week that Access has the capability to send emails utilizing Word and Outlook. We have the Office 2010 bundle.
My problem is this:
We have over 200 staff members at a newly opened organization and my boss is having problems with setting up a system that will receive queries to an email address and subsequently send out an email detailing informations from our access database using a line of code in said email to communicate with access.
The information for example would be credential expiration dates, and the query would be for who's information that would expire within two weeks from the date the email request was being sent.
I know the rough basics of a server needing to be set up and connected and connectable through internet, and about a few macros and coding not specific to Access.
If there is a website with code definitions and a guide on setting up email-to-Access-to-email messaging, that would be moderately helpful, but I love information straight from the horses mouth.
All prior searches through Google yielded applicable but vague information.
TL;DR
Need to set up outlook-to-access-to-word-to-outlook system to automate requests in code to retrieve Access database information. Anyone able to hand-hold for roughly two days on subject, or post link that already explains?
My problem is this:
We have over 200 staff members at a newly opened organization and my boss is having problems with setting up a system that will receive queries to an email address and subsequently send out an email detailing informations from our access database using a line of code in said email to communicate with access.
The information for example would be credential expiration dates, and the query would be for who's information that would expire within two weeks from the date the email request was being sent.
I know the rough basics of a server needing to be set up and connected and connectable through internet, and about a few macros and coding not specific to Access.
If there is a website with code definitions and a guide on setting up email-to-Access-to-email messaging, that would be moderately helpful, but I love information straight from the horses mouth.
All prior searches through Google yielded applicable but vague information.
TL;DR
Need to set up outlook-to-access-to-word-to-outlook system to automate requests in code to retrieve Access database information. Anyone able to hand-hold for roughly two days on subject, or post link that already explains?
Last edited: