Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

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

Re: passing cell contents to email hyperlink subject line??

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.

Re: passing cell contents to email hyperlink subject line??

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

thanks dude!

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.