View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Expanding =HYPERLINK() functionality in include BODY

Try:

=HYPERLINK("mailto:"&C35&"?subject="&$A$1&"&body=" &$a$2,A35)



JMay wrote:

This is working fine:

=HYPERLINK("mailto:" & C35 & "?subject=" & $A$1,A35)

But can I ADD-ON a reference to the "?body="

where in Cell $A$2 = "This is data to pass into my email body"

Thanks,


--

Dave Peterson