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




--
Regards
Dave Hawley
www.ozgrid.com
"ladyblue214" wrote in message
...
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