Link in outlook to a Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a link in Outlook to an Excel worksheet? I would like the
link to be equivalent to using;

Insert/File/Insert as Hyperlink (for a workbook)

However I would like to include the worksheet name (or something equivalent
in the path) so that the link will open to a particular worksheet.

Any help would be appreciated.
 
Version of Outlook/Excel? What is your message editor?

Try this: If using Word as the message editor, open your excel program to
the desired spreadsheet. Enable the web toolbar. Copy the address from the
web toolbar and paste it into Word. It should show as a hyperlink. Right
click on the hyperlink and select "edit hyperlink" from the context menu (or
highlight the link and press Ctrl+K). You can now change what is displayed
as the text for the hyperlink by changing the display name.


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, SA330 asked:

| How do I create a link in Outlook to an Excel worksheet? I would
| like the link to be equivalent to using;
|
| Insert/File/Insert as Hyperlink (for a workbook)
|
| However I would like to include the worksheet name (or something
| equivalent in the path) so that the link will open to a particular
| worksheet.
|
| Any help would be appreciated.
 
Hi Milly,

Thanks, however the problem I have is not creating a hyperlink to a workbook
but rather a specific worksheet with in the workbook, do you know how to do
that.

Thanks
 
Okay - then perhaps you might be better served to ask in an Excel group if
that is possible.

You may need to create a bookmark for the specific tab in order for this to
work, but, like I said, best to post to an Excel news group where the Excel
experts hang out.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, SA330 asked:

| Hi Milly,
|
| Thanks, however the problem I have is not creating a hyperlink to a
| workbook but rather a specific worksheet with in the workbook, do you
| know how to do that.
|
| Thanks
|
| "Milly Staples [MVP - Outlook]" wrote:
|
|| Version of Outlook/Excel? What is your message editor?
||
|| Try this: If using Word as the message editor, open your excel
|| program to the desired spreadsheet. Enable the web toolbar. Copy
|| the address from the web toolbar and paste it into Word. It should
|| show as a hyperlink. Right click on the hyperlink and select "edit
|| hyperlink" from the context menu (or highlight the link and press
|| Ctrl+K). You can now change what is displayed as the text for the
|| hyperlink by changing the display name.
||
||
|| --Â
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. All
|| unsolicited mail sent to my personal account will be deleted without
|| reading.
||
|| After furious head scratching, SA330 asked:
||
||| How do I create a link in Outlook to an Excel worksheet? I would
||| like the link to be equivalent to using;
|||
||| Insert/File/Insert as Hyperlink (for a workbook)
|||
||| However I would like to include the worksheet name (or something
||| equivalent in the path) so that the link will open to a particular
||| worksheet.
|||
||| Any help would be appreciated.
 
Back
Top