benf101
8/4/2016 - 8:45 PM

Make output into a clickable link in Excel. Put "=hyperlink( [...] )" around the output and when you paste it into excel it will be a link.

Make output into a clickable link in Excel. Put "=hyperlink( [...] )" around the output and when you paste it into excel it will be a link.

SELECT DISTINCT 
	lastname, firstname, '=hyperlink("C:\' + some_value + '.jpg")'
FROM [table_with_link_values]