Macros and Email

[Lisa]

I am trying to create a database that gets data from a different source as
well as new data managers will have to put in. The data from the other source
will insert itself directly into our database, but I want to know it it is
possible to have an email sent out to those who dont fill in the new data.

In other words, there will be a blank 'description' column to be filled out
for each new data entry. If the manager leaves the column blank, I want an
email to be sent to them so they will remember to fill it in. Is it also
possible to send this newly filled out data back into the database somehow. I
obviously don't know much about access and was wondering if any of this was
even possible. Any advice is greatly appreciated.
Thanks!
Lisa

 

[Steve Schapel]

Lisa,

Yes, this is probably possible to do with Access. It probably would not
be possible with macros... you would probably need to use a VBA
procedure. The srtucture of the data would obviously need to support
the functionality, i.e. you would need the email addresses of the
managers to be related to the records which you are trying to validate.
And depends, I suppose, what this mysterious "different source" is.
So, only a vague answer is possible on the basis of the information you
gave, but hopefully it will be helpful.