I'm using MS Access 2010 and I have a bunch of Send Object emails that reference tables and queries and sometimes the attachments contain no data.
If "no data" record count=0, I would like to send the email attachment, but in the subject line indicate some additional text indicating "no data".
This way they know that the report was run, but I'm hoping they see "no data" within the subject line to know that they can delete the email.
If "no data" record count=0, I would like to send the email attachment, but in the subject line indicate some additional text indicating "no data".
This way they know that the report was run, but I'm hoping they see "no data" within the subject line to know that they can delete the email.
