I do not believe that Project Server 2007 sends an e-mail message
automatically when a functional manager approves or rejects a Timesheet
submission. I believe you would need to use custom software development to
achieve this notification via e-mail. In that case, you might want to
repost this question in the microsoft.public.project.developer newsgroup to
let our software developer friends assist you. Hope this helps.