Y
YATZ
Hello, I have a MS access table that gets data when a form tagged to it is
filled. A person has to fill this form and sometimes all the information is
not available when the form is filled. The table has the following fields.
job id (auto number) date (today) customer purchase order job
status project file other fields
I need a solution to deliver the following results.
When one of the field is empty for a particular job id, I need Microsoft
access to automatically generate an email of the row to a pre-defined list
of email addresses, 5 days after the value in the date field. If the fields
continue to remain empty I would like the email to continue until they are
filled.
filled. A person has to fill this form and sometimes all the information is
not available when the form is filled. The table has the following fields.
job id (auto number) date (today) customer purchase order job
status project file other fields
I need a solution to deliver the following results.
When one of the field is empty for a particular job id, I need Microsoft
access to automatically generate an email of the row to a pre-defined list
of email addresses, 5 days after the value in the date field. If the fields
continue to remain empty I would like the email to continue until they are
filled.