Need to create Distribution List with Members

I am trying to figure out how to create a distribution list in Excel along with automatically adding all of the email addresses listed in the spreadsheet.

1. I would enter the name of the distribution list I want to create in Cell B1
2. In C3 until end of list (end of column with data), I need to take those email addresses and add them automatically to the new distro list.

I have figured out how to create the distro list, but cannot find any code to add members as needed.
I have also figured out how to take all of the email addresses and create a new email, but when I have over 4300 email addresses it really takes a long time for Outlook to unfreeze and appears to work faster with distro list.SampleDistro.xlsx

Please Login or Register  to view this content.

Any help or guidance would be greatly appreicated.

After searching google for a while, I found a code that creates the distro and adds members

http://www.tek-tips.com/viewthread.cfm?qid=1697914

Please Login or Register  to view this content.