Hi,

I want to know is it possible to generate the consolidated Report in Excel Automatically when the content from all the list get expired, as soon as the content get expired the mail should trigger to content owner along with the consolidated report.I have created the Information management policy through which i am able to set the content Expired date and using sharepoint designer i am also able to trigger a mail, the only part remaining is to generate the consolidated report for all the list items from all the lists.Please help me if any one know something about these.

Hi,

You can follow this article to see how to export SharePoint list to Excel programmatically:

http://www.mssharepointtips.com/tip.asp?id=1155

And the requirements in this thread is similar with yours, you can create a timer job combine with the export method:

http://social.msdn.microsoft.com/Forums/en-US/1e3ccc41-cf41-449e-a66d-d307519c326f/content-expiry-in-sharepoint-2010

Thanks,

Kenon Yin