My team has set up a basic knowledgebase in Sharepoint that collects a variety of article items for our Helpdesk team. We have enabled content approval so the submitted items will go into a pending queue until the list admin approves. Once approved we are interested in automating an email to go out alerting the helpdesk team a new item has been added to the KB list. I was thinking I could enable alerts for the team, however it seems the Content Approval and Alerts have no relationship or not dependent on each other. Because when I submitted a new item an alert was sent out to everyone even though the item is pending. I want the alert to be set up to where, when the item is approved the alert is sent out to everyone. Is this possible? Am I missing a setting? We are using basic SP features. I am on Moss 2007.
thanks!