concatenate & mailto:A1

[zakasnak]

I am using this formula to pull an email address from cell A1 : =HYPERLINK("mailto:",A1)

A1 contains the formula to create the email address : =HYPERLINK(IF($X$8>0,(CONCATENATE($X$8,"@company.com")),""))

H4, the destination cell, shows the email address in the correct format & is hyperlinked. However when I click the cell, a new mail message opens, but the email address does not appear in the TO box.

Any ideas?

 

[Domski]

Maybe: =HYPERLINK("mailto:"&A1,A1)

Dom

 

[Domski]

You should also just need to use this in A1:

=IF($X$8>0,(CONCATENATE($X$8,"@company.com")),"")

No need to HYPERLINK that unless you particularly want to.

Dom

 

[zakasnak]

Maybe: =HYPERLINK("mailto:"&A1,A1)

Dom

Worked perfect! Thank you!