Emailing table results

[KeyWestLover]

I would like to have my macro/vba send an email based on the results of two tables, or if both tables are null, i'd like the email to state that.

Is this possible? I'm having a terrible time figuring this out, and it "seems" a small request, but maybe I'm mistaken. :banghead:

Thank you in advance for your assistance

 

[David R]

DoCmd.OutputTo will be your friend here... depending on whether you want Excel, PDF, whatever for the output.

When you say the 'output' of two tables, do you mean a query? You can use a variety of methods to get the number of rows (DCount is easiest, but slow), and if it's 0, don't even bother trying to make the OutPutTo, just change the email text.

 

[KeyWestLover]

Thank you David, I'll put this together and give it a spin