Emailing Muliple Reports

[GWILKIE]

I run a end of day report of daily sales by territory in NA. Currently I run a query to list the territories with sales then run a report for each territory listed showing their unique sales.
I would like to create a macro that reviews the list of territories and then emails the report for each territory.
Each territory has a macro with the report and email address loaded I just need something to execute the list.



It is important that a report is not sent to territories with zero sales so just sending a report to everyone will not work.

I was thinking maybe a if statement could be used in a macro. I have good knowledge of MS Access 2010 but do not work in SQL I need the basics.

[Dal Jeanis]

Yes, you can make macros work conditionally. http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

You'll make a macro that conditionally executes your other macros. You'll probably use DCount(something)> 0 or DSum(something) > 0 to determine whether the (sub)macros for each territory should be run.

[GWILKIE]

Thanks Dal for the help but this is what I was doing and I get a error message
I am using the IF[ASN query list]![Salesperson]=1 then rum macro related to Territory 1
Unfortunately I get an error that says it cannot find the [ASN query list]![Salesperson]

[Dal Jeanis]

What is [ASN query list]![Salesperson]?
Is "ASN Query List" the name of a form? If so, try using Forms![ASN query list]![Salesperson].

[GWILKIE]

It was a Query, I tried making a table and using the builder to point to the Salesman field but i get the same message that it cannot find the ASN table

here is the code
With CodeContextObject
If (.[asn list]!Salesperson = 1) Then
DoCmd.RunMacro "M_email ASN 01", , ""
End If