Need help witl Hyperlink in Email body

[schmick]

Hello everyone,

I'm having an issue with the hyperlink I'm trying to make.

The hyperlink is contained in an email created by the macro. The hyper link needs to refer to a file name provided in cell E3.

I'm having two issues.

1. The hyperlink is not registering spaces and stops at the first space therefore the file path is not complete (it should be R:\DESIGN\DESIGN TEMPLATE\Special Purchase Request\ but actually it comes out as R:\DESIGN\DESIGN)

2. How do I refer to the cell to get the filename?

Please Login or Register  to view this content.

[Leith Ross]

Hello schmick,

Your HTML syntax is wrong. Try this.

Please Login or Register  to view this content.