Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink
Can anyone tell me how to make a hyperlink in a cell, so when you click will
open in Microsoft Outlook, with the email address in the address field. "Angie G." wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink
Saved from a previous post:
With the email address in A1, the subject in A2 and the body in A3: =HYPERLINK("Mailto:"&A1&"?subject="&A2&"&body="&A3 ,"click me") If you don't have the body of the message, just leave that portion off: =HYPERLINK("Mailto:"&A1&"?subject="&A2,"click me") or even: =HYPERLINK("Mailto:"&A1,"click me") Angie G. wrote: Can anyone tell me how to make a hyperlink in a cell, so when you click will open in Microsoft Outlook, with the email address in the address field. "Angie G." wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hyperlink function into hyperlink | Excel Worksheet Functions | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |