Hi,

I wonder if anyone could help me?

I'm trying to create a formula that will create a hyperlink which when
clicked will create an email with a url in the subject line that I will
collect from another part of the spreadhseet, I've started creating the
formula:

=CONCATENATE("mailto:",L2)

On my worksheet L2 is a valid email address, but not even this is working.
How can I convert the concatonated text into a hyperlink?

Can anyone help?

Hi,
try

=HYPERLINK(L2&";")

"Bishopsgate3466" wrote:

Hi,

I wonder if anyone could help me?

I'm trying to create a formula that will create a hyperlink which when
clicked will create an email with a url in the subject line that I will
collect from another part of the spreadhseet, I've started creating the
formula:

=CONCATENATE("mailto:",L2)

On my worksheet L2 is a valid email address, but not even this is working.
How can I convert the concatonated text into a hyperlink?

Can anyone help?

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")



Bishopsgate3466 wrote:

Hi,

I wonder if anyone could help me?

I'm trying to create a formula that will create a hyperlink which when
clicked will create an email with a url in the subject line that I will
collect from another part of the spreadhseet, I've started creating the
formula:

=CONCATENATE("mailto:",L2)

On my worksheet L2 is a valid email address, but not even this is working.
How can I convert the concatonated text into a hyperlink?

Can anyone help?

--

Dave Peterson