Weekly defects report

Hi,



My boss wants to receive a weekly report as follows:



1. Detailed list of active bugs

2. Detailed list of bugs closed\fixed in the past week

3. List of new bugs found in the past week



I know how to create this ad-hoc but how can I  have it sent over to him adn others and do this automatically on a weekly basis?



Thanks,

Asaf