| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinking e-mail addresses from a listing to show a subject lin
Try adding ?subject=testing", Code: -------------------- =HYPERLINK("mailto:" & INDEX(Sheet2!G:H,MATCH(Sheet1!A4,Sheet2!G:G,FALSE) ,2), INDEX(Sheet2!G:H,MATCH(Sheet1!A4,Sheet2!G:G,FALSE) ,2)) & ?subject=testing", -------------------- -- bgeier ------------------------------------------------------------------------ bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822 View this thread: http://www.excelforum.com/showthread...hreadid=547894 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete multiple addresses in excel before mail merge | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| How can I prevent email addresses from automatically hyperlinking. | Excel Worksheet Functions | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
Threaded Mode
