I need to email charts from an excel spreadsheet to specific users in our organization. For example, I have a spreadsheet with 120 charts, each chart will need to be automated and emailed to certain users on a daily basis. I am not sure on the best solution for this?
Can I take a snapshot of the chart save it to disk and then email it to the users? Should I just import the raw data into SQL Server table and then re-create the charts and then email from there? could i do this in Excel using some type of VBA? Any ideas, samples, example would be appreciated.