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!

Word can't merge an image from a hyperlink; it needs the actual image path. You can:
• maintain the full paths and image filenames in a field in Excel; or
• insert the path into the mailmerge main document itself, retaining just the image filenames in a field in Excel.
For more information, see Managing Mailmerge Graphics in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]