=HYPERLINK("MAILTO":N2?subject="&$Z$2"&body="$Z$3")
I'm using an article from another site that shows one can use concatenated fields to create subject body.
But I haven't been able to get it working.
What I want is: 1)Create hyperlink that pops up my outlook based on N2 (this works) 2) Creates the subject from field Z2 3)Creates the body from field Z3.
It seems putting the cells in quotes makes it text but there is no explanation as to how it works.
Thanks for any help.
I'm using an article from another site that shows one can use concatenated fields to create subject body.
But I haven't been able to get it working.
What I want is: 1)Create hyperlink that pops up my outlook based on N2 (this works) 2) Creates the subject from field Z2 3)Creates the body from field Z3.
It seems putting the cells in quotes makes it text but there is no explanation as to how it works.
Thanks for any help.