Problems sending file link in email
 

Hi all,

I am attempting to send an email notification to a group of people through
Excel VBA. I want to include a link to the Excel file in the body of the
email to enable quick access. The problem is that there are spaces in a
folder name, and in the file itself, and the "link" stops at the first space
it encounters. The entire path/filename is there, but the underlined link
stops at the first space.

How do I fix this? TIA for your help.

Problems sending file link in email
 

Hi M. Authement

See this Outlook example
http://www.rondebruin.nl/mail/tips2.htm

You can also send links in the body

..Body = "file://Yourcomputer/YourFolder/Week2.xls"

If there are spaces use %20
..Body = "file://Yourcomputer/YourFolder/Week%202.xls"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"M. Authement" wrote in message ...
Hi all,

I am attempting to send an email notification to a group of people through Excel VBA. I want to include a link to the Excel file
in the body of the email to enable quick access. The problem is that there are spaces in a folder name, and in the file itself,
and the "link" stops at the first space it encounters. The entire path/filename is there, but the underlined link stops at the
first space.

How do I fix this? TIA for your help.

Problems sending file link in email
 

DOH!!! I was using your site as a reference and I completely missed your
example with spaces. Thank you!


"Ron de Bruin" wrote in message
...
Hi M. Authement

See this Outlook example
http://www.rondebruin.nl/mail/tips2.htm

You can also send links in the body

.Body = "file://Yourcomputer/YourFolder/Week2.xls"

If there are spaces use %20
.Body = "file://Yourcomputer/YourFolder/Week%202.xls"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"M. Authement" wrote in message
...
Hi all,

I am attempting to send an email notification to a group of people
through Excel VBA. I want to include a link to the Excel file in the
body of the email to enable quick access. The problem is that there are
spaces in a folder name, and in the file itself, and the "link" stops at
the first space it encounters. The entire path/filename is there, but
the underlined link stops at the first space.

How do I fix this? TIA for your help.