TFS Team Project Manager automates various tasks across Team Projects in Team Foundation Server. If you find yourself managing multiple Team Projects for an organization and have recurring tasks and questions that repeat themselves over and over again, Team Project Manager helps.
No, I'm afraid this tool won't help with that. The purpose of this tool is to help automate certain tasks across many Team Projects, whereas in your case it will be automating a repetitive task within one Team Project. There might be other tools that support your need, or you can certainly build something with the Team Foundation Server API (which should be fairly easy actually).