Automatically send email to recipients list

  • Thread starter Thread starter rharaksi
  • Start date Start date
R

rharaksi

Hello, I have a MS access table that gets data when a person fills out a
form and sometimes all the information is not available when the form is
filled, and results in some null fields. The table has the following fields.
job_id(auto number) date(current date) customer_purchase_order
job_status project_file comment

I need a solution to deliver the following results.
When one of the fields is empty for a particular job id, I need Microsoft
access to automatically generate an email of that 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 reoccur daily until they
are
filled.

Thanks, any and all help will be appreciated.
 
Back
Top