I am kinda relatively new to this topic of Scheduling and sending reports to people using BCA. Is there a way that reports after refreshed (using BCA) can be sent to people (who use private emails) via email in a automated process.
You can either use the BCA Scheduler:
Add a VBA script in your document, which sends it per E-Mail.
Schedule a job in the BCA Scheduler, which uses that document and start the macro.
Or u can use the BCA Publisher, which allows u to distribute reports per E-Mail.
Problem: BCA Publisher needs an additional license, which is not cheap.