email excel file in access similar -thread181-877231

[Super2]

thread181-877231

I can email using sendobject. I email a excel file but I don't want to email it if it is empty. I either want to not email it at all or email a "no data" message in the email subject line if it is empty. How can I do this?

 

[JerryKlmns]

If you export a query to excel from access, you could check if the query exported, has no records! You 'll have to use VBA for this

 

[Super2]

I am acutally sending a query as an excel file.I guess I should be checking for the query being empty and then deciding what email to send (file or message). I am not sure how to check the query for being empty before sending email.

 

[PHV]

how to check the query for being empty
One way (VBA code):
If DCount("*", "yourQueryName") = 0 Then
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886