Modifying an email macro

The following code works great but I would like to use a range of cells for the To Recipient (instead of hard coding).

Please Login or Register  to view this content.

My email addresses are stored on worksheet "LawsonData" column AB, rows 2 thru 426. The length of this list varies depending on data I pull from our financial system. I can post a sample workbook if needed. Any help on adjusting this code would be greatly appreciated.

I have also posted this question here http://www.ozgrid.com/forum/showthread.php?t=167727 but have yet to receive a response.

Thanks in advance
Ryan