Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,182
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VLOOKUP hyperlink to mailto function on different worksheet Akahsa Excel Worksheet Functions 0 December 17th 09 12:35 AM
Using "mailto" hyperlink to email the workbook as an attachment Gilthoniel Excel Discussion (Misc queries) 2 November 13th 08 08:15 PM
How do I copy a hyperlink in a mailto: to a new cell in Excell? natboyd6 Excel Discussion (Misc queries) 0 September 30th 08 04:45 PM
Hyperlink mailto - ref cell for mail subject LDUNN1 Excel Worksheet Functions 2 October 25th 06 02:01 PM
=HYPERLINK("mailto: KurtB Excel Discussion (Misc queries) 2 October 24th 06 03:05 PM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"