Merging Hyperlink issue

[d.forbes]

Hi, thanks for taking the time to read this.

I just want to preface this by saying I have tried every method I can find on how to merge an active URL (inluding one found on this forum), however no matter which one I try I always come back to the same issue.

The issue is that once I complete the process, the hyperlink is not linking only to the URL, it is also linking to the file path of where the spreadsheet I am grabbing the data from is located. For example, instead of the link being 'www.website.com', the link is coming out as 'C:\users\filepath\filepath\filepath\www.website.com'.

It may also be worth noting that each URL is different and is specific to the intended recipent.



Again, thanks in advance, any help is much appreciated.