|I tried Jennifer's solution in XL 2003 and while it does make the text *look* like a hyperlink, I needed to go into each cell and double click it (i.e. put it into Edit mode) before it would actually become a hyperlink that would open my e-mail app.|
There may be some way to select the whole column and force all cells into Edit mode in one action, but I don't know what that is.
If you want to use my code, there are multiple ways to do it. The easiest would be to do this:
Right-click the sheet tab for the sheet with the email addresses in it and select "View code". Paste the code into the window that opens. (If there are 2 panes, use the upper one)
To run it, click the Green triangle or chose Run...Run Sub/UserForm or click anywhere within the code and hit F5.
BUT - you need to make sure you change the Range that the code will work on. Where I have A1:A45, you need to put the actual Range that contains your e-mail addresses, and it must be enclosed in quotes.