[keirax3]

Guys, help an intern out :
My boss sent me the details :

Current manual intervention includes:
- Export defect list from JIRA system, copy paste to excel
- Populate data for Daily Defect list
- Populate data for Closure Rate
- Populate data for Ageing JIRA
- Copy all graphs and descriptions to email

You can tackle the problem above by:
- Automate all the points
- Suggest to replace excel with another platform
- Etc.
Currently we are not looking at purchasing tools to do this. What I have in mind is more of a Excel Macro approach to:
- Accessing JIRA DB to retrieve defect data
- Generate an email template based on the reporting data

One of the possible outcome for this is, in Excel:
- One sheet for user to specify details (JIRA Project, defect search criteria, etc)
- A button to click and generate all data, based on pre-build SQL statement in one sheet (using Macro)
- A button to copy everything on the sheet to email template (using Macro)


Any suggestions for me and how to get started