I want to have a hyperlink in excel that when clicked will open up MS
outlook, with the email address in the address bar.

I have one column that will work on one workshee; but not sure why it won't
work on the 2nd worksheet.