making a cell a hyperlink

**ravihotwok** · 06-02-2009, 04:53 AM

I have a table which as a few columns, the left column is called name and the far right one is called email. The name cells have a drop down list which refers to another workbook with peoples names, when you select a name other cells are automatically populated using the vlookup function such as phone number, email etc. In the workbook it is referencing too with all the data, the email address are like a hyperlink which creates an outgoing mail if you click on it, is there a way to have this in the table as nothing happens when you ckick on the text.

Sorry if this is a bit muddled

**ravihotwok** · 06-02-2009, 05:04 AM

other way round, I want the function to be enabled in the table, so when you pick a person and the contact information cells are populated, if you click on the email address I want it to automatically open outlook and creat a new mail. It does it in the other workbook but not in the table one

**ravihotwok** · 06-02-2009, 05:07 AM

i dont know if it is actually a hyperlink, it just opens a new mail with the email address all filled in so would be a nice little function for the table