link to excel file causes runtime error

[jeff]

Hi all,

I have a hyperlink in an Outlook 2000 email that links to
a Microsoft Excel 2000 file that contains vba code. The
Excel program generates the error however it's based on
how the link is handled in Outlook.

When I click the link through the preview window in
Outlook everything works fine. The link looks like this -
<\\sfna-fs4\hrs\shared\ctm training\ctmtrainingsignup.xls>

When I open the email (i.e. view the email in it's own
window) and then click the link I get the runtime error in
excel. The link display look likes this - \\sfna-fs4
\hrs\shared\ctm training\ctmtrainingsignup.xls

Obviously, the second link is identical to the first
except Outlook has now removed the bracketts.

Basically my question is how does Outlook handle these
links? Why are they handled differently? How can I make
sure the link is handled correctly in Outlook so that
whether the user is clicking the link in the preview pane
or through the opened email they get link that doesn't
cause the error?

Thanks in advance for your help.

Jeff

 

[Sue Mosher [MVP-Outlook]]

How Outlook handles the links depends in part on the mail format. If you're
generating an HTML format message, you should use an <a> link.