b6f95285_r_not___videos____Office_Blogs__Question
[Answer] Say that you have first names in column A and last names in column B. You can combine the ampersand symbol (&) and the HYPERLINK function to build email addresses. When you click the link, your e-mail program automatically starts and creates an e-mail message with the correct address in the To box. [See for yourself] Video: Create a mailto hyperlink [Question] 
How can I create email links from the text in several different columns?
Hyperlinks in Excel: Hot or not? (videos) - Office Blogs
Question