| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink in body of VBA email | Excel Discussion (Misc queries) | |||
| How to include Excel charts in Outlook email *body* with VB | Excel Programming | |||
| Expanding a data table to include an extra row | Excel Discussion (Misc queries) | |||
| Expanding VBA to include more than one column | Excel Programming | |||
| Expanding the F9 functionality | Excel Programming | |||
Linear Mode
