Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink with Mailto, concatenate, from other sheets in the same workbook
I don't understand. I have read everything from past postings but I do not understand why the bellow function isnt working. =HYPERLINK("mailto:"&Setup!H16&"?subject="&'T1'!B2 :M2&"&body='T1'!A17:C17, "Email") I am trying to make it so that once information is tryped into a cell that I can click a link to open a email with subject cell and email auto populates. I may have lost my mind and I am sorry but if there are any Excel pros out there please help. Thank you. - Billy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink with Mailto, concatenate, from other sheets in the same workbook
I don't understand. I have read everything from past postings but I do not
understand why the bellow function isnt working. =HYPERLINK("mailto:"&Setup!H16&"?subject="&'T1'!B2 :M2&"&body='T1'!A17:C17, "Email") I am trying to make it so that once information is tryped into a cell that I can click a link to open a email with subject cell and email auto populates. I may have lost my mind and I am sorry but if there are any Excel pros out there please help. Thank you. - Billy The Subject parameter expects a string; -you're trying to pss it an array. Try putting the contents of B2:M2 into a contiguous (single) string. Not sure but almost certain the Body parameter won't accept an array either. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VLOOKUP hyperlink to mailto function on different worksheet | Excel Worksheet Functions | |||
Using "mailto" hyperlink to email the workbook as an attachment | Excel Discussion (Misc queries) | |||
How do I copy a hyperlink in a mailto: to a new cell in Excell? | Excel Discussion (Misc queries) | |||
Hyperlink mailto - ref cell for mail subject | Excel Worksheet Functions | |||
=HYPERLINK("mailto: | Excel Discussion (Misc queries) |