Thanks suresh

That sparked an idea to another solution ...

We used the Database Mail service with SQL agent to send the report and wrote a small .Net application and used the...

Thanks for the help everyone ...

We ended up using a security product from ApexSQL (that did a 2 week job in 2 hours). Cannot recommend it highly enough !!!