Goal:
I would like to have users be able to click a button that will do the following upon click (aka, request):
- Run Specific Reports
- Attach Said Reports to a Specific Template
- Email Said Template to a Specific Address
- Refresh the Page
- Display a Message to the User that their request has been submitted
I am familiar with how to achieve steps #3, #4, and #5, but I am at a loss of how to do steps #1 and #2.
Is this even possible with Salesforce? Do you have any ideas?
Please let me know if you have any questions.
Thanks!