SharePoint 2010 Site Alerts Possible?

See more:

SharePoint

Hi All, this my first time asking a question on here, so here goes..

We currently run SharePoint 2010 foundation environment using the product
as document repository with approval settings activated.

At this stage everything runs smoothly with approvals expect notifying
the document uploaded that there document has been either Approved or Rejected.

Now I know we can use the built in Alert Function with SharePoint but some of our sites have a huge amount of document libraries to which we don’t want our users and myself to go through each one and setup and alert for it.

I have gone down the Workflow road with SharePoint Designer and checked out what can be done; basically I found that I can only do this strictly for Document libraries one at a time which is the same for the alert function. Having said that my knowledge of workflows with SPD is kinda limited so if I’m missing something here let me know?

SO..this brings me to a question, I would like to know IF it is possible to setup alerts at sites levels. I would like to create alerts for document approval/rejection per site can this be done with say custom code?

I have searched google for answers but it looks like this cannot be done without custome code?

any help would be great!