Specify an email list from table, instead of in VBA

Sorry for the wonky title, not sure how to word it...

Here's my code

Please Login or Register  to view this content.

for the emailItem.To - how can I specify each email address from a table, lets say it's a table named "recipients" on a sheet named "settings"

Something like this. Update TableName and ColumnName accordingly.

Please Login or Register  to view this content.