Send email only when query or report has data

[Jmsteph]

Hello,

I have a macro that runs each night to email files and do other misc things on the database. The only thing is that I have a query that it e-mails each night that very rarely has data on it. I'd like for it to only send the e-mail when there is data in the query so that I don't overwhelm the recipients with pointless emails. Has anyone come up with a way to do this?
Thanks,

 

[boblarson]

Do you say you are using a MACRO or VBA code (since you posted in the VBA /MODULES area)?

For VBA you can use something like this:

If DCount("*", "yourQueryNameHere") > 0 Then
   ' ...do your stuff here
End If

 

[Jmsteph]

That will do it. I have the macro call the nightly cycle, but I can have it send the email through VBA so that works.
Thanks,

JS

 

[boblarson]

You can run a macro from VBA:

DoCmd.RunMacro "MacroNameHere"