Email macro help (1 Viewer)

[aftershokk]

I have 6 queries that are audit reports of data. I have a batch file that opens MS Access on my PC once a week and emails these 6 query results to 2 users. Many times the results of the queries are empty. What I want to do is only "send object" (email) to the user if the results have data in them.

Example: if count of audit report 1 is 0 or null, do not email otherwise email

any help is appreciated, I am not the great with VBA so please bear with me

thanks