You need to set a default profile (public or private). In SQL Management Studio, go to Database Mail, then create your mail profile. Once you have done that go to 'Manage profile security' and assign the profile you created as the default profile to be used (change the "
no" to "Yes").