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 runs each
of the individual Macros, but the ones that do not get a
report for that day would end up getting a
blank report every day. How can I set a report up in a
Macro to bypass if there is no data?
Thanks,
Ls
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 runs each
of the individual Macros, but the ones that do not get a
report for that day would end up getting a
blank report every day. How can I set a report up in a
Macro to bypass if there is no data?
Thanks,
Ls