use outlook group to send email using excel 2013 vba

The below vba will send an automated email to a list of addresses in excel 2013 using outlook 2013. Instead of having multiple email addresses in excel, if a distribution list was created in outlook, can that list be used instead?

For Example, the current code looks to column A, starting at row 2 for an email.... then it sends an email to each address.

Please Login or Register  to view this content.

If each one of those email addresses was saved in an outlook group (email), could the group name (email) typed into A2 in the excel, then 3 separate emails sent? Thank you .


vba

Please Login or Register  to view this content.

Edit: I added

Please Login or Register  to view this content.

The email address from the contact list from outlook does not transfer to excel and in the To is "Email"
Error: outlook does not recognize the address.

Where is the distribution group to use specified or how does the vba know to use the (email) group? Thank you

The edit was an attempt at trying to achieve this, but it did not work.

edit: I see now, it works great.... thank you very much