Excel Button Macro (E-Mail Distribution List)

I have a Excel sheet with a few columns


Column AD is the Rank of person (Chief, Assistant Chief, Sergeant, Officer)

Column Y is the Email address for each person

What I would like to do is the following.


Have a form or page with the rank of each available person and a check box next to their rank.

I then want to click the groups I want want to send an email to and then click a button that says send email.

I then want Outlook to pop up and it put those officers email in the Recipient field and nothing else.

Is this possible and if so, could anybody give me a small walkthrough.

I know I can create distribution lists in outlook, but those get outdated, this is getting its info from our most reliable source which is our Employee Database.

Thanks a lot.

Matt

No thoughts guys?