Sending an e-mail from Excel - Hyperlink question

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

Hi all,

i am not a programmer, but a newbie dabbler.

I am sending an e-mail via excel and want to know if it is possible to
insert a hyperlink in the body of the e-mail, so that the receiver of the
e-mail can just click on it to open the path, which is on our server ??

Any help is much appreciated.
 
Yes, such a URL would look like this:

file://\\ourserver\ourshare\outfolder\ourfile.xls

or

file://z:\outfolder\ourfile.xls

If the file or folder name contains spaces, you'll need to replace each
space in the URL with %20.

If the message is in plain text format, you can simply include the URL in
the Body property. If the message is in HTML format, you'll need to include a
full <a> tag in the HTMLBody property, just as you would in a web page.
 
Same syntax; omit the file name.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Back
Top