Macro to Send to a Distribution List with a Macro

In my Outlook 2007, I have the following Address Book Lists.
Global Address List
Contacts
Pricing (path \\Mailbox-Myname\Contacts\Pricing

With in the Pricing Address list, I have several Distribution Lists. One I have made named "test" for the purpose of testing this macro.

I have found this macro to email the workbook. I want to email it to the "Test Distribution List" in the Pricing Address Book List.

How do I specify the distribution list in the macro? Where I have the .To "Test" does not seem to be picking up the distribution list.

Please Login or Register  to view this content.