I would like to extract email addresses from an Excel document

[ladyblue214]

I have a spreadsheet of names and addresses. I would like to extract the
email addresses to put in an email to send out to all. Can this be done

 

[ozgrid.com]

See http://www.ozgrid.com/VBA/HyperlinkAddress.htm