Hi all,
I want to know how to set the office 2003 email sound notification.

This is actually set in Control Panel under Sounds. You can set various sounds to go with various event.