Send mail based on current record or other

A

amccriri

My database is updated many times over a 30-60 day period. Initially, a
specific user enters information through a userform. Then I update the
database from time to time and am required to email the originating party the
update.

How do I call the auto number field and return the matching table filled
with email addresses?

For example, I update record # 4 with two pieces of data, the date and the
tracking number. When I press "save this record", I need an email to the
originator of the record telling them on a certain date a tracking number is
available.

Any help is much appreciated. Thanks.
 
Top