Multiple tones for texts or emails?

[Jen in NCal]

I am totally new here and totally out of my element. I have a Droid X that I do not plan on rooting. Mainly because that scares me to no end.

Is there a way or an app that I can assign different tones to different contacts for message notifications like I can for ringtones?

Thanks! And be kind to the new girl, she's intimidated enough.