|Subject:||If query has not records -"no records found" to be output in query out/report|
|Date:||23 Aug 2006|
I am currently running a marco that run a query and emails the results
as an attachment in excel format. If the query has no records, I would
like to email "no records found" in the first cell in the excel
attachment. I have a feeling that this needs to be done in VB, but I
don't know that much about VB. Would using a report instead be a
better and easier way of doing this?