How to create email, adn add hyperlink for workbook filepath?

**Rerock** · 09-01-2012, 11:04 AM

Hi!
I'm attempting to put a hyperlink in an automatic email that the recipient can click and go to the folder where the file is located on our network.

There are two tricky parts to this:
1) The path is not a fixed location (the excel file is for pricing bids/quotes, and each project has its own folder).
2) The names of the folders contain spaces.

This code works great provided there are no spaces in the file path:

Please Login or Register  to view this content.

From my searches, if the filepath contains spaces (which ours does), they need to be replaced with "%20".

Running a test with the current code, the hyperlink breaks at the first 'space', then the remainder of the filepath is simply text (not blue and underlined).

Does anyone know a fix, or have an alternative solution altogether? I'm open to anything as long as it works!

Thanks!

**BuckoAk** · 09-03-2012, 05:03 PM

Give this a try.

Please Login or Register  to view this content.

**BuckoAk** · 09-07-2012, 12:33 PM

If your happy with your answer, be sure to mark you post as [Solved].
At the Top Right of your Post You can:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

You can also give credit by clicking on the Star at the bottom left of the supporting post.

**Mike1001** · 09-07-2012, 12:43 PM

Hey BuckoAk, that's great!
It doesn't look perfect, since the prefix and suffix are shown as well in the e-mail, but it works !!!!

**BuckoAk** · 09-07-2012, 09:28 PM

Mike,

I didn't catch it at first, what do you mean the prefix and suffix are shown.
Are you not seeing this below (See Image) when the email is created? Did you adjust the code by chance?

**BuckoAk** · 09-11-2012, 02:51 AM

If your happy with your answer, be sure to mark you post as [Solved].
At the Top Right of your Post You can:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

You can also give credit by clicking on the Star at the bottom left of the supporting post.