VBA question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have Access send an email to certain individuals when a
conditon is met in a particular field. For example if I have a field called
"Retest Date" and the restest date is 08/25/05, I would like Access to
automatically send an email to our QA department to alert them that the
retest date has come and the drug needs to be retested. I am not really that
familiar with VBA and I don't know how difficult this would be to achieve.

Thanks in advance for any help.

Best regards,

Dee
 
hi,
you can setup a hidden form, where in Timer event you query this field say
every minute. once it have required value - you can send message via
outlook, using docmd.sendobject or using automation (lot of samples you can
find at support.microsoft.com)
 
Back
Top