I am trying to output individual reports based on the number of records on my table.
Basically I have a table with a number customer and I want to output a report for each customer separately.
Attached I have the example. For customer 002 I need report Customer002, for customer 003 I need Customer003, etc.
I need in Excel format and in Snapshot format. Export to a certain directory.
Is that possible? I was trying to build a macro but every time I add a new customer I have to modify the macro and it can be a long list.
Any help appreciated.

here is the database. Appreciate any advice.