The Comcast email has no provision for sound alerts. So it must be coming from whatever device you are using, or an email client like Outlook or Thunderbird, etc. So the answer will depend on how you are accessing your email.
I am not a Comcast Employee. I am a Customer Expert volunteering my time to help other customers here in the Forums. We ask that you post publicly so people with similar questions may benefit from the conversation. Was your question answered? Mark the post as Best Answer!