There is something called “Scheduled Reports” which will generate the Report every week. I’m not sure if it has an option to sendit in an email, though.
Sending an email when an Opportunity is created is a simple Workflow, module Opportunities, run for new items, action: send email