I have a macro that the Actions are to SendObjects (Qrys) as attachments via Outlook.

I would like a condition placed that if one of these qrys do not have any records (null), that the SendObject cmd for that particular qry is skipped and then the macro goes to the next SendObject line.

I've spent hours looking through the threads but still can't find what I'm looking for. ANY guidance is greatly appreciated!!!:confused:

I don't use macros, but you should be able to put a DCount in the condition area, basically testing for >0.

Thank you Paul for your reply....I did as you mentioned, but then I rec'd a mismatch type error!! It's been a LONG DAY!

Tried this as a macro condition and it worked fine:

DCount("*","QueryName")>0

YOU are a godsend! Thank you, I didn't use the *. THANK YOU so much!! :)