ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Expanding =HYPERLINK() functionality in include BODY (https://www.excelbanter.com/excel-programming/426746-expanding-%3Dhyperlink-functionality-include-body.html)

JMay

Expanding =HYPERLINK() functionality in include BODY
 
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

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

JMay

Expanding =HYPERLINK() functionality in include BODY
 
Thanks Dave; I was trying to use the "?" before the "body" - thatis ?body="
thinking it was necessary as it is in ?subject="

"Dave Peterson" wrote:

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



All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com