How would I E-mail a view to a role group?

I am trying to make a site that would have stories that would be scheduled to start and end publish into a particular view. These would be visible as a view, but would then also be sent as an e-mail on a scheduled basis to a role. I am wondering how I can accomplish this. I will say how I have tried so far, and see if any of the drupal gurus have a way to finish the process. I am currently doing this with drupal 4.7, but would do it with 5.x if all the parts are there for it.

To do this, I use the story content type, create a story, then using the views module, I create a view that only picks up stories, not pages or other content type. Next I use the scheduler module to set the un/publish time of the story, so it will automatically show up and disappear from the view at the correct time (no sense saying Merry Christmas in July...) Then I use the actions module and create a custom action that successfully e-mails a node to a role group, this works for a node, but not a view. Lastly I use the view scheduler module to do an action on a view - here is where the problem is though (two actually). The view scheduler will do an action on a view, but it does it on each item in the view individually, so saying e-mail the view would actually send however many individual nodes you have in a view to each member role - ie a person might get 10 e-mails instead of one. Secondly it doesn't actually send any email at all. I know the "email to role" custom action that we created works because we use it for workflow (tell users in a role when a new piece of content is created and needs to be approved), but it doesn't do anything when I use the view scheduler. The view scheduler does change the nodes in the view to be in the moderation queue (if I choose that action) at the scheduled time, so the view scheduler module works, it just doesn't send email. Anyway back to the real question, how would you make an information email site like this? Any modules that exist to do this, or any module that you think could be easily modified to do this? Any help would be appreciated. Drupal is so flexible that I am sure this is possible - I just need some pointers on how to make it happen. Thanks in advance!

liveoutloud2day