I remember using this mod a while back, before the most recent big update and it let me zoom out way more then you can by default. I found this really useful.

You can find it here still: http://wowui.incgamers.com/ui.php?id=1603

But it's currently not working with the most recent patch. Is there anyone that can fix it?

I'd be muchly appreciated.

Thats strange, I think mines still working.

Here, you can DL it if you want.

Download Link

Downloaded and replaced the files, I still cant zoom out anymore.

Is there a way of activating it or something?

Don't you have to go to Interface Options and, under "Camera," change the option titled "Max Camera Distance," or something like that? I'm not sure, never used this AddOn, but this would be my first guess...

EDIT: Just downloaded it, and it seems to me that my solution was correct :P
Hope I helped, lol

Did you follow the link to the new improved version provided at the top of the page you linked?
http://wowui.incgamers.com/ui.php?id=3108

The following two console commands, entered once only, achieves what we want:

/script SetCVar("cameraDistanceMax", 25)
/script SetCVar("cameraDistanceMaxFactor", 2)

IMPORTANT: Make sure to remove ImprovedCamera first!