Emailing Database Objects

[Jessica240]

Hello all!

I am creating a macro which will open and email a report to a group of co-workers. The control source for the report is a query that has a parameter as the criteria.


In the macro, I have several different values that are used as the parameters to populate the query which then feeds into the report.




There will be times when the database will not have any data that matches the parameter criteria. When this happens, a blank report is sent. My goal is to find a way to only send reports with data and avoid sending blank reports.

So is there some way I can tell Access to only send the email if the value is not null?



Thanks for the help!

[June7]

Bing: stop macro if no data in report

Review:

http://www.dbforums.com/showthread.p...p-Macro-in-VBA

https://www.accessforums.net/macros/...ata-48076.html

[Jessica240]

Thanks. The problem is that I am completely new to macros and have never used VBA. I've been trying to teach myself online and so far this link has been pretty helpful https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

But still, macros are so foreign to me so I really have no idea what I'm doing. All I can do is very basic actions such as open report, email report, close window. So when I read these forum posts, it all looks like alien language and is far too advanced for my amateur brain to understand.

[June7]

I don't use macros, only VBA.

Those threads suggest an If Then conditional structure in VBA code. I know macro has equivalent.

The conditional code uses a DCount domain aggregate function (DLookup would work as well) to determine if report will have records after filter criteria is applied.

You will have to explore If Then conditional in macro and domain aggregate functions.