Email a Report to a list of email addresses created dynamically from a sheet
I have several reports that I would like to send out to people who do not have access to SmartSheet. I can go into the report and "Send as Attachment" and enter their names. But It would be easier to have a sheet with a list of emails in one column and "Send as Attachment" to that list of addresses. It would be even nicer if I could have this happen on a set time - weekly, etc. Again I know from within a report I can "Send as Attachment" and create a scheduled send. But again I want to draw from a list of emails.
The list of emails is not huge, but it is large enough and changes enough that I want to be able to have novice users add emails and delete emails from the list as needed as the recipients come and go from the organization.