First of all, the tools I have available to me are SharePoint Designer and InfoPath, and I am much more comfortable in the former than the latter.
I have a request to create a solution to facilitate communication from my team to related teams. What they would like to do is have program managers enter their weekly updates, then have an email generated that would pull all of these together, which would then be reviewed by the team lead before going out to the other teams. The next week, the PMs would enter new updates, and a new email would be generated using those updates, and so on and so forth.
The thought that occurred to me first was some sort of workflow on a timer that would send out weekly, but I don't know how it would pull in data from multiple items.
Has anyone implemented something like this?