Is it possible to schedule a workbook to run on a daily or weekly basis and have the results automatically emailed to a recipient?

not natively. it's kind of disappointing they haven't added that functionality to be comparable to searches.