It should play the default 'Mail Notification' sound; you can set your desired sound by clicking on Browse 3.

I had to jump through a few hoops to make sure it worked properly:

Set 'Play a...