sp_send_dbmail can only send to an address that conforms to an actual email address format, ie firstname.lastname@example.org; you cannot send to just "MyGroup"
a group account is handled special by an exchange server; it is optional to expose the group to external resources outside of the domain, so you have to get the mail admin to map email@example.com; to your group; when the exchange mail server receives the email, it will process it and duplicate the email out to each of the real members of the group.
get with your Exchange admin to create that or to make sure you know the mapped email for it.
it's optional specifically because it would be too easy to get spam from outside world with a firstname.lastname@example.org going out to everyone, for example.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!