Can I create a dynamic email address in Excels hyperlink?
 

Is there a way to insert carriage returns in the HYPERLINK formula?

For instance, in the mailto, I want the body to be:
Top line
Middle line
Bottom line



"sebastienm" wrote:

Hi,
You can use the HYPERLINK(url, displayed_text) formula, but it would have to
be in another column:
=HYPERLINK("mailto:" & ", "mail " & Q13 & " " & R13)
Would that work for you?

Regards,
Sebastien

"mtkatrev" wrote:

I'd like to take names from a list in excel and create email addresses from
them. For example:
Associate Name:
Tom Smith
If "Tom" is in one cell (Q13) and "Smith" is in the next (R13) I can compose
an email address in cell S13 with ". I'd then like to
set up a hyperlink in cell Q13 that refers to cell S13 that contains
.

yes, for displayed_text, enter a series of strings separated by CHAR(10) to
create a new line within the same cell. Also, and very important, format the
cell with Wrap Text (menu Format Cell, tab Alignement):

"A" & CHAR(10) & "B"
returns:
A
B
within a single cell.

So, within the HYPERLINK formula:
=HYPERLINK("mailto:" & ", "A"&CHAR(10)&"B")
would show:
A
B
highlighted as a hyperlink.

Regards,
Sebastien

"ibrettferguson" wrote:

Is there a way to insert carriage returns in the HYPERLINK formula?

For instance, in the mailto, I want the body to be:
Top line
Middle line
Bottom line



"sebastienm" wrote:

Hi,
You can use the HYPERLINK(url, displayed_text) formula, but it would have to
be in another column:
=HYPERLINK("mailto:" & ", "mail " & Q13 & " " & R13)
Would that work for you?

Regards,
Sebastien

"mtkatrev" wrote:

I'd like to take names from a list in excel and create email addresses from
them. For example:
Associate Name:
Tom Smith
If "Tom" is in one cell (Q13) and "Smith" is in the next (R13) I can compose
an email address in cell S13 with ". I'd then like to
set up a hyperlink in cell Q13 that refers to cell S13 that contains
.