Using IncludePicture and MailMerge to insert picture that is taken from a a picture lookup in Excel

[nic-nax]

Hi,



I apologize in advance as I have no idea what I'm doing. I have a spreadsheet that essentially has a data validation to choose a code from in the first column and then the next few columns all return pictures by using named formulas and linked pictures. All of this is working exactly as I want it to so far.

I then have a word document and I'm trying to create a mail merge that will return these pictures. I've read about using INCLUDEPICTURE, but does this only work if I then specify a location for the picture, rather than just hope it appears from excel?


None of my documents are complete, they are all just tests to see if what I want to achieve can actually be done, so any help would be greatly appreciated!