We have a site which houses our Work Instructions. This site has about 10 subsites (one for each major area of operation). Each subsite has a Pages Library and a Document Library.
I'm trying to create a workflow that checks the pages library of each subsite for the page "review date". Once that review date is reached, I need to send an email to the Page Owner requesting that they review and update the page. Most often there are numerous pages with the same review date so I'd like to create a notification that looks like:
The following pages are due for review:
Ideally the workflow will be a site workflow so I only need to maintain the one workflow.
Any help would be appreciated! Thanks.