Thread: email hyperlink - cell value in subject line
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.misc
[email protected] arbhungani@gmail.com is offline
external usenet poster
  
Posts: 1
Default email hyperlink - cell value in subject line
On Thursday, December 13, 2007 at 2:20:01 AM UTC+5:30, boustrophedon wrote:
I want to make an email hyperlink that includes text and a cell value in the
subject line, like this: Status Change [Data!A1] .

Is there an easy way to do this or do I have to VB it?

=IF(G23=0,"",HYPERLINK("mailto:"&R23&"?body="&$M$2 2&"%0A"&M23&"%0A"&$L$22&"%0A"&L23&"%0A"&$O$22&"%0A "&O23&"%0A"&$G$22&"%0A"&G23&"%0A"&$I$22&"%0A"&I23& "%0A"&$K$22&"%0A"&K23,"send"))*HYPERLINK("mailto:" &R23&"?body="&$M$22&"%0A"&M23)

how I am chang of L23 cell valu in date formate in body ?
Reply With QuoteReply With Quote