Hi, we are looking for an expert in Access and VBA for a one-off micro project.
The function of the database is to gather relevant project information through an automated email communication with the managers. The database has already been created (forms, reports, queries), we just need to create a function to gather the relevant data through automated emails. Your task – to enable managers to receive an auto email (monthly), fill in the table and send it back – the gathered info should be collected automatically and recorded in the Access table columns (see under 1) through the managers replied emails.
More detailed - our database is intended to:
1) Based on the query “ProgressReportQuery”, we want a form, preferably as a simple Excel-file with the table entries, sent out to the person under the column “TWApprover” in table “ProjectDefinition” for each project. The column “TWApprover” is a drop-down list from the query “PMFilter”, which is linked to the table “PeopleTable” where the emails for each person are stored.
We would like a function that sends out the forms automatically once every month to the relevant emails, and lets the “TWApprover” for each project fill the “ProgressReportQuery”-entries in so that data are automatically stored in the database when sent back.
2) As an additional function, if within our budget, we would like to be able to prompt “TWApprover”s that does not fill in the form every day until it’s filled in, either through an alarm system, or through automatically resending the form.