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

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