Automatic Email notification from tables in access

  • Thread starter Thread starter ccadez
  • Start date Start date
C

ccadez

Hi,

My question involves sending out an automatic email message
notification from access. This is the scenario. When fields in a
table are being filled out, if there is one that does not get filled
out then I would like an email to be sent out. The email would be sent
out to whoever the person in the company should have filled out the
information (sales, accounting, etc.). Also with the possibility of
there being multiple and different recipients. Each field would be
designated for a specific person or department (sales, accounting,
etc.). Any help on this would be greatly appreciated.

Thanks,
Chris
 
[email protected] said:
Hi,

My question involves sending out an automatic email message
notification from access. This is the scenario. When fields in a
table are being filled out, if there is one that does not get filled
out then I would like an email to be sent out. The email would be sent
out to whoever the person in the company should have filled out the
information (sales, accounting, etc.). Also with the possibility of
there being multiple and different recipients. Each field would be
designated for a specific person or department (sales, accounting,
etc.). Any help on this would be greatly appreciated.
Click to expand...

My first thought is, why can't you design the app so the user cannot leave
out the required information in the first place? Every table field has a
Required property that prevents it from being left blank.

Secondly, are your users entering data driectly into tables or are they
going through forms? Allowing users direct access to tables is almost never a
good idea. All data should be entered and accessed through forms and reports.

If you really do need to send email, Access has no event model built into
tables; it cannot check for missing data and initiate an action. This means
that anything like this will need to be done through forms. Here is a good
FAQ to get you started on how to send emails from Access:
http://www.granite.ab.ca/access/email.htm

Barry
 
Back
Top