Apologies for this rather amateur question.
I have a SP site with a number of content types, each of these have their own retention policy (eg. 3 years, 5 years).
Before items get deleted, I want to give the site admins a 7 day warning that a document is going to be deleted. However, the users don't want a flood of emails and have asked for a "daily summary" notification not unlike the way Alerts work in SP that allow for a daily summary of changes in a library.
Could someone give me a hand explaining the required components I would need to generate this daily "expiring" items notification? How do I build the "list" of items that would get added to the email notification?