automatic password protected emailed reports

Question

Hi All,

My Client has requested that i email him reports daily and that they are password protected.

Before I write a service to do this, I was wondering if there is not a better alternative.

The data is stored in an SQL 2005 database with DB mail setup and running.

We are also using reporting services.

The option he has given me are Excel or PDF, but his main requirment is the password protection.

Thanks