| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel(with hyperlinks) as a message body of outlook mail
I have an excel file with multiple sheets. The first sheet has hyperlinks to
the remaining sheets in the file. But when I send this sheet as a message body, the hyperlink references change. I would ideally want these links in this sheet which is send as the message body, to link to the excel from which it is generated. I would be grateful if you could suggest a way around. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel(with hyperlinks) as a message body of outlook mail
It sounds like the workbook name was included in the hyperlink.
I like to use the =hyperlink() worksheet function to do this kind of stuff. David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) hans wrote: I have an excel file with multiple sheets. The first sheet has hyperlinks to the remaining sheets in the file. But when I send this sheet as a message body, the hyperlink references change. I would ideally want these links in this sheet which is send as the message body, to link to the excel from which it is generated. I would be grateful if you could suggest a way around. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outlook message in Excel | Excel Discussion (Misc queries) | |||
| Stop excel emedding (opeing in mail format) when outlook is open. | New Users to Excel | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Excel 2003 / Send To / Mail Recipient / body text is removed | Excel Discussion (Misc queries) | |||
| help with excell to outlook for mail merge | Excel Worksheet Functions | |||
Linear Mode
