This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
My data source is an xlsx file and one field (PictureLocation) has the full path name of each jpg file I want to merge into a document. I use this merge function: {INCLUDEPICTURE "MERGEFIELD PictureLocation}"} which works fine except I only get a box with a small red x in upper left-hand corner where the picture should be. I have tried F9, but to no avail. What am I doing wrong or what have I set incorrectly? I use VISTA and OFFICE 2007. dottybee
A family of Microsoft word processing software products for creating web, email, and print documents.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
What is in the PictureLocation field?
The filepath separators need to be duplicated \ or you need to use / as a separator.
I'm not sure WHY I thought this since I gave instructions explicitly for Word 2007. <sigh> Can I plead sleep deprivation?
Sorry for all the red herrings. Go with Doug's advice from now on.
The suggestion that Suzanne has made about linking to a picture has taken you off the track.
Do you have picture files with the filenames of name1.jpeg, name2.jpeg? You must have pictures with the filenames that you have included in the data source.
What is the path to the folder that contains those pictures?
In your mail merge main document, what do you see if you press Alt+F9 to toggle on the display of the field codes?
In it, you should see { MERGEFIELD "First Name" }, { MERGEFIELD "Last Name" }and a field construction such as the following where you want the picture to appear:
{ INCLUDEPICTURE "DriveLetter\folderpath\{ MERGEFIELD Picture }" }
where DriveLetter\folderpath\ will be something like C:\Users\username\Pictures\ (Note you can use either \ or / as the path separators)
If you want the pictures to be all the same size, insert the above field construction into the cell of a one cell table with fixed cell dimensions.
Note, that after you execute the merge to a new document, you will need to use Ctrl+A to select everything in the document and then press F9 to update the fields in the document for the correct picture to be displayed for each record.
Actually, to be 100% more accurate, there are no <> around name1.jpeg - it just says name1.jpegFirstname Lastname.