All you need to do is adjust the notification settings for each app instead if the main settings for the Droid. For instance, open the Gmail app and click settings. There you will see a notification option as well as notification tone options. The same holds true for the SMS app.