I am working on an access database where I have to email a few people if there are columns in the table whose values are null.

The email must contain the rows in the table containing nulls in a specific columns. Im aware of that I can do the emails thru the sendobject macro. But I just have no idea how I can check for conditions before running the macro.

Can anyone show me how?