Stop SendObject Macro

[OpsO]

I have created a simple database that makes two tables from external data. Then compares the two tables and makes a table from the resulting differences. Then it sends the results in excel format to a designated email address for action by my employees. On some days, there are no differences between the two tables. Is there a way to stop the SendObject macro if there are no records present in the table?



Thanks in advance for any help on this

[pbaldy]

If I understand correctly, you can test to see if the differences table has any records, and only send the email if it does. I'd do it with code, but you should be able to use a macro condition as well. A DCount() would be the simplest way to test the table.