Hyperlinking to folder in email

[stroffso]

Hi,
I am trying to send a link in an email to a folder directory, the email is created using the hyperlink function in Excel. So in a cell I have =HYPERLINK("mailto:"&D2&"?subject="&$BA$1&"&body="&received&[@[Unique ID]]&update,"Send Email")

This opens up a new email with the text exactly how i want it, however the bit that says update is actually a named range to the following drive C:\Users\Stroff\OneDrive\Time\Watch

When it comes through on an email though its just plain text,I was wondering is there any way to make the folder directory an actual link using the afore mentioned hyperlink formula? Reason I am using this is I have hundreds of rows

thanks in advance

 

[Héctor Miguel]

AFAIK this works to open a folder with hyperlink function:
=HYPERLINK("file:////"&update,"Open folder")
=> BUT... a link in mail body needs HTML, and mailto links do NOT create an HTML email body

HTH
hector.