Hi Veerle,
This is very possible. Once you have built the report, you would need to set up a Scheduled Workflow Rule that sends this report to a certain user every week. To go to the schedule workflow rule you would need to go to Settings > Configure > Create new scheduled workflow rule.
Comment actions