Hello!

I am looking to include images in an Excel sheet from a hyperlink into the folder they're stored in. The hyperlinks look like this: \\\\*REDACTED*-srv01\\Commons\\Services\\!Projects\\*REDACTED* Inspection 2024\\*REDACTED* Advisory_2024-12-10T091203\\images\\262021362.jpeg

I'm trying to use MailMerge to insert the pictures in each of these cells that are connected to their respective part numbers. The images are stored in a commons folder, and I want to figure out how to pull the picture from the link instead of having to drag and drop the pictures one-by-one.
This is the formula currently being used for this cell: =LET(path,XLOOKUP(A3#,oisTag,oisPic01),IF(path<>"" ,"\\\\*REDACTED*srv01\\Commons\\Services\\!Project s\\*REDACTED* Inspection 2024"&SUBSTITUTE(path,"/",""),""))

I hope this makes sense. If you have any advice or solutions please let me know!