L
Les
I send reports to several clients on a daily basis. When
I started my business, there were only a couple of
clients and I set each of the reports up in a Macro
(SendObject) and life was good. Now I have several
hundred clients of which only some receive reports on any
given day and each day it is a different group of clients
that get the report, so I manually go down the list and
send each individual report by clicking on their Macro. I
would like to set up a send report Macro that has all of
the runs each of the individual Macros, but the ones that
do not get a report for that day would end up getting a
black report every day. How can I set a report up to
bypass if there is no data?
I started my business, there were only a couple of
clients and I set each of the reports up in a Macro
(SendObject) and life was good. Now I have several
hundred clients of which only some receive reports on any
given day and each day it is a different group of clients
that get the report, so I manually go down the list and
send each individual report by clicking on their Macro. I
would like to set up a send report Macro that has all of
the runs each of the individual Macros, but the ones that
do not get a report for that day would end up getting a
black report every day. How can I set a report up to
bypass if there is no data?