Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 115
Default Hyperlinks to .msg files

When I we create a hyperlink to a .msg document (which was created in
Windows 2000) on the network , the error message 'cannot open specified file"
is displayed.

I am using a Windows XP machine and I believe the same problem occurs for
Windows 2000 users when trying to open hyperlinks to Outlook messages from my
machine.

Do I need to convert the .msg files to another format in order to open them?
Or is there another way of doing this by preserving the file format?

Any suggestions would be most welcome!


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Hyperlinks to .msg files

maybe the filepath contains spaces? Did you try it with a msg, saved in
the root of a networkdrive? Of did you try it with the same filename,
only having another extension. e.g. did you save a Worddocument in the
same way.
By the way how (and why) did you make a hyperlink to the document?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 115
Default Hyperlinks to .msg files

Have tried to save again - this time creating a filename without spaces.
Hyperlinks are inserted into the Excel spreadsheet using insert/hyperlink
and pasting the full path of the file into the address line and text to
display line.
Still get error message 'cannot open file' The Excel document is saved in
the same directory.

Where do I go from here?

Many thanks,

" wrote:

maybe the filepath contains spaces? Did you try it with a msg, saved in
the root of a networkdrive? Of did you try it with the same filename,
only having another extension. e.g. did you save a Worddocument in the
same way.
By the way how (and why) did you make a hyperlink to the document?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Hyperlinks to .msg files

Can you post or send me the Excelsheet? Watch out, don't mention any
personal information, maybe even better make a new sheet with only a
simple msg hyperlink.
Besides, you don't have any problems with hyperlinks to other
documents?

Zakynthos schreef:

Have tried to save again - this time creating a filename without spaces.
Hyperlinks are inserted into the Excel spreadsheet using insert/hyperlink
and pasting the full path of the file into the address line and text to
display line.
Still get error message 'cannot open file' The Excel document is saved in
the same directory.

Where do I go from here?

Many thanks,

" wrote:

maybe the filepath contains spaces? Did you try it with a msg, saved in
the root of a networkdrive? Of did you try it with the same filename,
only having another extension. e.g. did you save a Worddocument in the
same way.
By the way how (and why) did you make a hyperlink to the document?



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Hyperlinks to .msg files

And one more question, when you double click the msg, will it open as a
normal email (in a Outlook window)?

Zakynthos schreef:

Have tried to save again - this time creating a filename without spaces.
Hyperlinks are inserted into the Excel spreadsheet using insert/hyperlink
and pasting the full path of the file into the address line and text to
display line.
Still get error message 'cannot open file' The Excel document is saved in
the same directory.

Where do I go from here?

Many thanks,

" wrote:

maybe the filepath contains spaces? Did you try it with a msg, saved in
the root of a networkdrive? Of did you try it with the same filename,
only having another extension. e.g. did you save a Worddocument in the
same way.
By the way how (and why) did you make a hyperlink to the document?





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 115
Default Hyperlinks to .msg files

Hi,

I've emailed you directly a sample (blank) SS containing a single hyperlink
saved in the same way, together with a print screen of the error message - I
don't know whether this will be of help to you in offering a possible
solution, but I thought it was worth a try.

Many thanks for your help!

" wrote:

And one more question, when you double click the msg, will it open as a
normal email (in a Outlook window)?

Zakynthos schreef:

Have tried to save again - this time creating a filename without spaces.
Hyperlinks are inserted into the Excel spreadsheet using insert/hyperlink
and pasting the full path of the file into the address line and text to
display line.
Still get error message 'cannot open file' The Excel document is saved in
the same directory.

Where do I go from here?

Many thanks,

" wrote:

maybe the filepath contains spaces? Did you try it with a msg, saved in
the root of a networkdrive? Of did you try it with the same filename,
only having another extension. e.g. did you save a Worddocument in the
same way.
By the way how (and why) did you make a hyperlink to the document?




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Hyperlinks to .msg files

The hyperlink in your Excelsheet contained dubious information. The
text shown was G:\project1\test.msg, but the actual hyperlink (the link
to the 'file name') was defined as
\\servername\GROUP\TEXT19\TEXT19\project1\test.msg
(I changed some text for security reasons).

You mentioned some people weren't able to open the hyperlink. This is
caused by the server path, unreachable for them. Maybe the have other
mappings to the same directory. In that case refer only to the drive
mapping G:\

Change the hyperlink in the excelsheet by using right click on the
hyperlink, choose hyperlink, edit hyperlink. Especialy the 'file name'
should be accessible for all users. The text to display can even be
short e.g. "test email".

I think it gives you a lot of craft to create all those hyperlinks.
Good luck



Zakynthos schreef:

Hi,

I've emailed you directly a sample (blank) SS containing a single hyperlink
saved in the same way, together with a print screen of the error message - I
don't know whether this will be of help to you in offering a possible
solution, but I thought it was worth a try.

Many thanks for your help!

" wrote:

And one more question, when you double click the msg, will it open as a
normal email (in a Outlook window)?

Zakynthos schreef:

Have tried to save again - this time creating a filename without spaces.
Hyperlinks are inserted into the Excel spreadsheet using insert/hyperlink
and pasting the full path of the file into the address line and text to
display line.
Still get error message 'cannot open file' The Excel document is saved in
the same directory.

Where do I go from here?

Many thanks,

" wrote:

maybe the filepath contains spaces? Did you try it with a msg, saved in
the root of a networkdrive? Of did you try it with the same filename,
only having another extension. e.g. did you save a Worddocument in the
same way.
By the way how (and why) did you make a hyperlink to the document?





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
Relative Hyperlinks to local files CR Optiker Links and Linking in Excel 3 April 5th 06 06:05 AM
Hyperlinks to files on network drivers Fornol New Users to Excel 3 February 22nd 06 11:10 PM
Hyperlinks to .pdf files comet Excel Worksheet Functions 1 December 7th 05 03:58 PM
I have problems with hyperlinks to Adobe pdf files STEVESEY Excel Discussion (Misc queries) 2 April 29th 05 07:02 PM
hyperlinks to bookmarks in pdf files tonynguyen Excel Discussion (Misc queries) 1 January 28th 05 02:11 AM


All times are GMT +1. The time now is 03:12 PM.

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

About Us

"It's about Microsoft Excel"