let me correct my last line -

Excel 2007 removed this limitations but we are still at Excel 2003. When I am exporting only one page report, why is it...

oh..okay..I missed the following -

7. Restart the SQL Server Agent

It worked.

Thanks

So, What was the fix for this? I am seeing the same issue here. The test mail goes fine but the actual job doesn't notify the job status.  Before running...