MrExcel Publishing
Your One Stop for Excel Tips & Solutions

passing cell contents to email hyperlink subject line??


Posted by Jarred Land on December 03, 2001 2:01 AM

is there anyway to pass the value (contents) of a cell to the subject line of a email hyperlink? Thanks in advance!
JArred


Posted by Dank on December 03, 2001 4:29 AM

Hello,

Say your subject is in cell A1 you can use the HYPERLINK worksheet function...

=HYPERLINK("mailto:contact@zoomforce.com?subject=" & A1,"Mail me")

Hope this helps,
Daniel.

Posted by Jarred Land on December 03, 2001 5:33 PM

thanks dude!